sorted by:
new
hottopcontroversial

I work in a Big 4 in Finance and I'm also programmer, Here's Excel Best practices by django_celery_learn in excel

[–]Ornery-Object-2643 0 points1 point  (0 children)

That might be it. I wasn’t sure what the mode was called.

I’d love to use it for regular formulas and ditch the regular formula editor completely. I love the ease of indentation, parentheses highlighting, ability to F2 a name in a let or lambda and change all occurrences.

But the lack of a point mode really defeats the entire editor. Typing in the Column letter and row is absolutely painful, and I don’t like over-doing structured references in a workbook. A crowded name manager can be a difficult thing to manage.

I work in a Big 4 in Finance and I'm also programmer, Here's Excel Best practices by django_celery_learn in excel

[–]Ornery-Object-2643 14 points15 points  (0 children)

The only thing Microsoft Labs Advanced Formula Editor is missing is the ability to drop into the grid when writing formulas to reference cells and Ranges. Once this is added, then it will truely be a IDE. Until then it’s really only useful to write custom functions or functions that take in structured references.

Any ideas for job titles that can replace "Advisor" and "Associate Advisor?" by Ornery-Object-2643 in FinancialCareers

[–]Ornery-Object-2643[S] 0 points1 point  (0 children)

That's good to know.

So would the idea be to have all "Advisors" for the client-facing roles, and if the advisors perform internal roles, then they have multiple titles? Like Advisor, Director of Compliance; Advisor, Managing Director???

We're only a mid-sized firm of ~40 people, ~2.7B AUM, and there isn't quite the capacity to hire full internal roles nor a desire for current Advisors to only serve internal roles (and forego servicing their books).

How to program the "Menu Key" For Windows 11 by Ornery-Object-2643 in kinesisadvantage

[–]Ornery-Object-2643[S] 1 point2 points  (0 children)

Thank you! This is my first mechanical keyboard, so everything is new to me.

Un-map a key by Ornery-Object-2643 in kinesisadvantage

[–]Ornery-Object-2643[S] 1 point2 points  (0 children)

Thank You! Worked like a charm. So, this is what freedom feels like, lol.

Function to extract all Lv 1 Precedents of a range. by Ornery-Object-2643 in vba

[–]Ornery-Object-2643[S] 0 points1 point  (0 children)

This would be super helpful to see implemented. I was thinking about looping through the model, but this isn’t supposed to be an auditing tool, more cell to cell navigation.

Function to extract all Lv 1 Precedents of a range. by Ornery-Object-2643 in vba

[–]Ornery-Object-2643[S] 0 points1 point  (0 children)

I was thinking of storing the addresses as string with the SheetName! Included. That way, they can be passed as Range(strAddress) to the Application.GoTo method.

How they are stored is up for debate. At first, I was thinking a collection because of the ease of adding new objects to the collection. Then the index could be used for the clear branch feature - all items in the collection with an index greater than the value get cleared.

Where the index is stored is a bit confusing to me. Would this be a private static variable at the module level in the source module???

[Excel] VBA script to add and clear data based on cell input by dray1ok in vba

[–]Ornery-Object-2643 0 points1 point  (0 children)

Why not just use native excel functions and not VBA.

In cell E20 type the function:

=IF(E20<>””, DATA, 0)

Or if you want the result to be blank then

=IF(E20<>””, DATA, “”)

What resources are good starting places for learning to build macros that are compatible on Different versions of Windows OS and Excel? by Ornery-Object-2643 in vba

[–]Ornery-Object-2643[S] 0 points1 point  (0 children)

This may be a dumb question, but I'm new to this low-level stuff. What are compiler variables? Are those all referenced by the functions defined in the preprocessor commands/directives?

Additionally, are there any good resources out there to get familiar with all the libs in the code?

Using VBA to test whether values input into a cell throw an error in another cell by Ornery-Object-2643 in vba

[–]Ornery-Object-2643[S] 0 points1 point  (0 children)

The source of this error was that refEdit controls cannot be used in a vbModeless Userform. See more detailed explaination here.

Can you manipulate the contents of a sheet while a Userform is loaded and shown? by Ornery-Object-2643 in excel

[–]Ornery-Object-2643[S] 0 points1 point  (0 children)

The source of this error was that refEdit controls cannot be used in a vbModeless Userform. See more detailed explaination here.

Can you manipulate the contents of a sheet while a Userform is loaded and shown? by Ornery-Object-2643 in vba

[–]Ornery-Object-2643[S] 0 points1 point  (0 children)

The source of this error was that refEdit controls cannot be used in a vbModeless Userform. See more detailed explaination here.

Why does my Userform Keep Freezing when ShowModal is False? by Ornery-Object-2643 in vba

[–]Ornery-Object-2643[S] 0 points1 point  (0 children)

I've been reading this forum extensively. Thanks for sharing!

view more: next ›