Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form Question
I have a section of my program that will display a different user form
depending on what a given input was (NT1s). I know that following will work to display the correct form but I was wondering if there was a way to use the variable "NT1s" in a single line to show the correct form. Something like ModConfig(NT1).Show As always, any help is greatly appreciated! If NT1s = 1 Then ModConfig1.Show End If If NT1s = 2 Then ModConfig2.Show End If If NT1s = 3 Then ModConfig3.Show End If If NT1s = 4 Then ModConfig4.Show End If |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form Question
Hi Tony,
Something like ModConfig(NT1).Show As always, any help is greatly appreciated! If NT1s = 1 Then ModConfig1.Show End If If NT1s = 2 Then ModConfig2.Show End If If NT1s = 3 Then ModConfig3.Show End If If NT1s = 4 Then ModConfig4.Show End If Su VBA.Userforms("ModConfig" & NT1s).Show Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form question | Excel Discussion (Misc queries) | |||
User form question | Excel Programming | |||
User Form Question | Excel Programming | |||
User form question | Excel Programming | |||
User form question | Excel Programming |