Share via

Excel VBA UDF Tool-tip/hint box

Anonymous
2022-05-04T16:12:52+00:00

Hello Everyone,

I am working on creating some UDFs in VBA, but I find it a bit deflating that I cannot create a tooltip as standard excel functions have, demsonstrated in the helow format:

Typed into a cell: =UDF

Excel shows (pops up next to the cell): =UDF[description]

Entered into a cell: =UDF**(** Excel shows (pops up next to the cell): =UDF(argument1,argument2,[argument3],...)

I have come to the conclusion that excel has not bestowed us with this honor yet, as a standard to the excel package- If I am wrong, PLEASE correct me.

Are there any python/add-in/etc. work around for this? The point is, I have quite a few arguments and quite a few UDFs, so it's really easy to get lost in everything (the units as well).

Thanks for reading/answering/sharing-my-pain,

Filip

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-05-04T20:28:29+00:00

    Perfect,

    I've done just that- Thanks!

    0 comments
  2. Anonymous
    2022-05-04T21:35:15+00:00

    Re: detest the shortcuts

    I provide an optional list (cheat sheet) of most the functions in the free 'Custom Functions' Excel add-in that I offer. It includes all of the arguments for the functions.
    It can help if you keep it handy. It requires some work but can make things easier...

    '---
    Nothing Left to Lose https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    0 comments