title: intellisense functionality in a custom VBA function?
body: <p>In the standard IDE for VBA, intellisense is built-in to many standard VBA functions.  i.e. the buttons variable for msgbox() gives you a list of options for how you want the messagebox to be displayed.  This way, the developer doesn't have to memorize or look up the options every time function is used.</p>
  
  <p>Can I achieve the same for my custom VBA functions? This is a rough example, but can i write something like:</p>
  
  <p><code>Public Function DoSomething(X as string)(Options X="Opt1","Opt2") as variant</code><br>
  <code>...</code></p>
  
  <p>When I call this function, I would get a pop-up giving my options for X as Opt1 and Opt2</p>