excel userform / vba

[p4nny]

Hi,

I would like certain controls to hide / display dependent on selected options in a combo box.

Please could you help?

For example

If "Birthday party" is selected in a combo box, then a further set of controls would appear asking questions such as name, age etc. If any other option is selected then hide the questions.

hope this is clear

many thanks

 

[Smitty]

See if this gets you started:

If Me.cbo_PartyTyp.Value = "Birthday Party" Then
  Me.tb_Name.Visible = True
Else
 Me.tb_Name.Visible = False
End If

Although if you're going to be changing the visibility of a bunch of controls with lots of criteria you might want to consider showing different forms, or use a Multi-Page control. Or at least use a Select Case structure instead of If's, which will get pretty long winded and hard to read.

HTH,

 

[p4nny]

thats great! thanks.

also, I would like the userform to display a calendar allowing the user to select a date? Ideally time additionally.

Is this possible?

thanks again for the guidance

 

[Smitty]

also, I would like the userform to display a calendar allowing the user to select a date? Ideally time additionally.

Do a search for MSCAL.OCX, or see: I Don't Have a Copy of mscal.ocx

Ron Debruin also created one that's probably more stable: Use a Calendar control or Date Picker to fill in dates