intellisense functionality in a custom VBA function?

Posted by PowerUser on Stack Overflow See other posts from Stack Overflow or by PowerUser
Published on 2010-04-01T15:11:54Z Indexed on 2010/04/01 15:13 UTC
Read the original article Hit count: 502

Filed under:

intellisense

|

vba

|

ms-access

In the standard IDE for VBA, intellisense is built-in to the standard VBA functions. Can I achieve the same for my custom VBA functions? i.e. can i write something like:

Public Function DoSomething(X as string)(Options X="Option1","Option2") as variant

© Stack Overflow or respective owner

Related posts about intellisense

Emacs X11 autocompletion (intellisense)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I use visual studio for day to day programming (read putting food in my mouth) but for personal programming (read c/c++ hacking) I use Emacs. Right now I am doing a programming exercise involving the X11 API. I am continually referring to the programming API manual to find the signature… >>> More
VS2010 Intellisense on class files

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Web Application Project that I'm working on. My solution looks like this : ./MyProject/ ./MyProject/dataobjects.cs <- no intellisense ./MyProject/sqlquerying.cs <- no intellisense ./MyProject/default.aspx <- intellisense works here ./MyProject/default.aspx.cs <- intellisense… >>> More
Over-enthusiastic Intellisense in VS2010 - can I tweak it?

as seen on Stack Overflow - Search for 'Stack Overflow'
Since I have upgraded from VS2008 to VS2010, I've been having an increasingly infuriating battle with the Intellisense. For example, when specifying CSS styles, when I press Enter to start an new line, Intellisense (appropriately) lists available Styles to me. And if I select color and then type… >>> More
Some VS 2010 RC Updates (including patches for Intellisense and Web Designer fixes)

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
[In addition to blogging, I am also now using Twitter for quick updates and to share links. Follow me at: twitter.com/scottgu] We are continuing to make progress on shipping Visual Studio 2010. I’d like to say a big thank you to everyone who has downloaded and tried out the VS 2010 Release… >>> More
Some VS 2010 RC Updates (including patches for Intellisense and Web Designer fixes)

as seen on Dot net Slackers - Search for 'Dot net Slackers'
[In addition to blogging, I am also now using Twitter for quick updates and to share links. Follow me at: twitter.com/scottgu] We are continuing to make progress on shipping Visual Studio 2010. Id like to say a big thank you to everyone who has downloaded and tried out the VS 2010 Release… >>> More

Related posts about vba

Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous! Voici un article sur la programmation des extensions OpenGL, en VB6/VBA Cet article décrit l'utilisation de quelques extensions fréquemment utilisées : - Les VBO (vertex buffer objects) pour améliorer les performances - Les textures 3D pour réaliser des textures continue sur… >>> More
VBA : Obliger une saisie numérique dans une TextBox - Approche d'une résolution de besoin en VBA niv

as seen on Developper.com - Search for 'Developper.com'
Bonjour, Ci-dessous, le lien vers un nouveau tutoriel : « Approche d'une résolution de besoin en VBA - niveau débutant - Obliger une saisie numérique dans une TextBox » Le but de ce tutoriel est : De présenter une bonne approche de la résolution d'un problème simple en VBA. D'expliciter en… >>> More
Run VBA macro when condition is met

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I'm creating a spreadsheet to train my numerical skills. Now, I use VBA macros to generate a new problem once the current one has been correctly solved. To do so, I still have to press a button in the worksheet, which costs time and is annoying. Is there a way that I can execute a… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Excel 2007 VBA macros don't work in Parallels

as seen on Super User - Search for 'Super User'
I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow Leopard. The spreadsheet contains VBA macros which connect to external Oracle db's over the Internet… >>> More