View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron[_11_] Aaron[_11_] is offline
external usenet poster
 
Posts: 2
Default Parameters with fixed set of possible values

How do I make a subroutine with a parameter that has a fixed set of
possible values? I want something similar to the box that pops up for a
boolean with only 'true' and 'false' options.

Also, is it possible to populate the pop up box with options such as
'red', 'blue' that correspond to values such as '1', '2'?

------
Aaron

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!