Functions in VBA

[Bob]

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

 

[JP]

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

 

[Bob]

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


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

 

[JP]

I know you want something like tooltip text, but it only seems to work
when you use the UDF in the VBE. You can always show the arguments if
you press Shift-F3. Make a suggestion to Microsoft to add this in a
future version?


HTH,
--JP

 

[Bob]

Thanks JP.

I know you want something like tooltip text, but it only seems to work
when you use the UDF in the VBE. You can always show the arguments if
you press Shift-F3. Make a suggestion to Microsoft to add this in a
future version?


HTH,
--JP