Combo Boxes

[FCC]

Hello,

I was wondering if there was a way to set the default value of the
combo box? Like I've populated my combo box with employee names taken
from the worksheets, and it works all fine and stuff. But instead of
the combo box showing a blank space on initialize, I would like it to
take the name of one of the employees by default.

Is that possible?

Also, regarding the calender control, is it possible to have the
calender always take the current date of the computer as the setted
default date?

 

[Norman Jones]

Hi FCC,

Try:

'=============>>
Private Sub UserForm_Activate()
Me.ComboBox1.Value = "Elvis"
Me.Calendar1.Value = Date
End Sub
'<<=============

 

[FCC]

Cool it worked. Do you know the ansert to the Initialize and Unload Me
concern that I have?