Re: Functions in VBA

Thanks JP. However, when I press Shift-F3, a dialog box opens. I was
looking to how a bubble help, similar to the built-in functions of excel, so
that as you type your function in the formula bar, to show the arguments.

Bob


"JP" <jp2112@xxxxxxxxxxxxx> wrote in message
news:396f1412-ec92-47e6-9981-ffdb6096d3bc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
    ... If you press Shift-F3 and choose "User Defined" from the dropdown ... you should see your UDF with its arguments. ... you are in Excel and press Shift-F3 again. ...
    (microsoft.public.office.developer.vba)
  • Re: Dynamic macro parameters
    ... the function parameter will only change if you use a reference as ... as Excel does not know that your '1' represents a row number ... The built-in functions do this, but I have not> been able to figure out how to make my functions do> this. ...
    (microsoft.public.excel.programming)
  • Re: How do I show what the percentage is of one figure to another?
    ... Microsoft MVP - Excel ... |> Hi Jane, ... |> All built-in functions of Excel and all the functions in Analysis Toolpak use this representation of percentages: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I show what the percentage is of one figure to another?
    ... But something in the logic of your spreadsheet is wrong, I think, if you're trying to find out what the percentage of zero is. ... Microsoft MVP - Excel ... |> Hi Jane, ... |> All built-in functions of Excel and all the functions in Analysis Toolpak use this representation of percentages: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How good is R?
    ... data management, transformation etc. ... tests) in Excel. ... don't rely on built-in functions too ... experience Excel can be superior to dedicated stats packages such as ...
    (sci.stat.math)