Emoncada
10-05-2009, 05:23 AM
I have two userforms. I have a ComboBox (CmbBoxDesktopQty) with values of 1-30 in userform1.
I have a cmdbutton that would hide userform1 and shows userform2. I would like for based on (CmbBoxDesktopQty) value to make certain things visible in userform2.
Example
If CmbBoxDesktopQty = 3 Then
Userform2.Lbl1.visible = true
Userform2.Txtbox1.visible = true
Userform2.Lbl2.visible = true
Userform2.Txtbox2.visible = true
Userform2.Lbl3.visible = true
Userform2.Txtbox3.visible = true
I think maybe using cases might work.
I set it up in the way that whatever the value is userform2 can match with value.
Example
Userform1.CmbBoxDesktopQty.value = 10
Then Userform2 Lbl1-10 & Txtbox1-10 would be visible.
Hope this is kind of clear and help would be great thanks.
I have a cmdbutton that would hide userform1 and shows userform2. I would like for based on (CmbBoxDesktopQty) value to make certain things visible in userform2.
Example
If CmbBoxDesktopQty = 3 Then
Userform2.Lbl1.visible = true
Userform2.Txtbox1.visible = true
Userform2.Lbl2.visible = true
Userform2.Txtbox2.visible = true
Userform2.Lbl3.visible = true
Userform2.Txtbox3.visible = true
I think maybe using cases might work.
I set it up in the way that whatever the value is userform2 can match with value.
Example
Userform1.CmbBoxDesktopQty.value = 10
Then Userform2 Lbl1-10 & Txtbox1-10 would be visible.
Hope this is kind of clear and help would be great thanks.