View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IanC IanC is offline
external usenet poster
 
Posts: 49
Default Showing Userform

Is it possible to use the show command for a userform, when the name of the
userform is stored as variable. Basically, I have a userform that leads off
to one of 10 other 'subforms' depending on the user's selection from a
dropdown. I have code that relies on If statements, etc, but it would be
easier when adding future 'sub-forms' if I could store all the userform names
in an array and then select the appropriate name from there.

I have all the array code, but cannot work out the Show command.