Adding intellisense to VBA functions

borntorun75

Board Regular
Joined
Jul 12, 2010
Messages
57
Hi there,

Is there any way of adding intellisense to my VBA functions ? Some of the functions I write have quite a few parameters to them, and it'd be nice to be prompted about which parameters need to be passed to the function which order.

As it stands, I'm constantly having to refer to the code to remind myself which order the parameters need to be passed.

Using Excel 2010.

Thanks, borntorun75
 
The short answer is no, you can't add full Intellisense. The best you can do is what Adam suggests.
 
Upvote 0
Thanks guys,

That looks like an interesting avenue to explore adam087 - I'll definitely have a try of that. Thanks RoryA for giving me that steer about implementing Intellisense in full- I'd rather know that than go round and round Google, etc. looking for false leads.

I think what adam087 has suggested will satisfy my requirements. My latest UDF takes in a lot of parameters and it's a bit of bind having to refer to code to remember parameter orders.

Thanks guys and the quick replies are very much appreciated.
borntorun75.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top