Adding intellisense to VBA functions

[borntorun75]

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

 

[adam087]

Good morning

Have a look at this. See if it helps.
http://www.mrexcel.com/forum/excel-questions/804518-udf-descriptions.html

/AJ

 

[RoryA]

The short answer is no, you can't add full Intellisense. The best you can do is what Adam suggests.

 

[borntorun75]

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.

 

[adam087]

Cool. Thanks for the feedback.

/AJ