Question on UserForms with variable options

[jameslytle]

Is there a way to set up a userform where it will show one option (i.e. a dropdown list) when one factor is selected but show another option (i.e a pure text box) when another factor is selected?

Or do I need to create two separate userforms and then depending on which factor is selected that particular userform will be initiated?

Jim

 

[Fluff]

Something like

Private Sub ComboBox1_Click()
   If Me.ComboBox1.Value = "Fluff" Then
      Me.TextBox1.Visible = True
   Else
      Me.ComboBox2.Visible = True
   End If
End Sub

Private Sub UserForm_Initialize()
   Me.TextBox1.Visible = False
   Me.ComboBox2.Visible = False
End Sub

 

[jameslytle]

Fluff,

Can this be done and both of the boxes occupy the same space on the userform or do they need to be offset? I am thinking they will have to be offset otherwise as it would make it hard to click on them during the development stage.

 

[Norie]

It might make things a bit fiddly having them on top of each other in development but there's nothing to stop you doing it.

If you didn't want to do that what you could do is, as well as making them visible, reposition them.