Combo Boxes
 

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?


--
FCC
------------------------------------------------------------------------
FCC's Profile: http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=557734

Combo Boxes
 

Hi FCC,

Try:

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


--
---
Regards,
Norman



"FCC" wrote in message
...

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?


--
FCC
------------------------------------------------------------------------
FCC's Profile:
http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=557734

Combo Boxes
 

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


--
FCC
------------------------------------------------------------------------
FCC's Profile: http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=557734