Re: Functions in VBA

If you press Shift-F3 and choose "User Defined" from the dropdown
category box, you should see your UDF with its arguments.

If you want to add a text description, go to the VBE and click
anywhere in your macro. Press F2 to view the Object Browser, then
select "VBAProject" from the upper leftmost dropdown box. In the box
on the lower left, select the module where you put your UDF, then
right click on the UDF name that appears on the right. Select
"Properties" and you can enter a description which should appear when
you are in Excel and press Shift-F3 again.

HTH,
JP

On Mar 3, 1:58 pm, "Bob" <some...@xxxxxx> wrote:
Hi everyone:

Does anyone, know that if I have created a function in VBA which I plan to
call from inside excel by typing it in the formula bar, how can I have excel
show the list of arguments needed, just like the excel's built-in functions?

Thanks for your help.

Bob

.

Relevant Pages

  • Re: Functions in VBA
    ... However, when I press Shift-F3, a dialog box opens. ... looking to how a bubble help, similar to the built-in functions of excel, so ... you should see your UDF with its arguments. ... you are in Excel and press Shift-F3 again. ...
    (microsoft.public.office.developer.vba)
  • Re: Formula Search (is it possible?)
    ... If you're asking about using the Edit/Find menu function, choosing ... Formulas in the Find dialog's Look In dropdown will look at formulas and ... If you're asking about a worksheet function, here's one way using a UDF: ...
    (microsoft.public.excel)
  • Re: removing early duplicates
    ... then drag fill this down the column. ... In the dropdown in B1, ... If this isn't what you want, post back with what you mean by UDF. ... Tom Ogilvy "Mike" wrote in message ...
    (microsoft.public.excel.programming)