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?

One last thing, I have this UserForm_Initialize() Sub which populates my combo box on initialization. Works perfectly. Now if there are no employees in the system, I want it to display a message and then the userform should close automatically since there are no employees. I tried using the Unload Me code, but I got the

Run-time error '91':

Object variable or With block variable not set

I am assuming it has to the with the fact that I can't have an Unload Me code inside an initialization sub. Is there a way to work around this?

[Norman Jones]

Hi FCC,

Try:

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


--
---
Regards,
Norman



"FCC" <FCC.2acik0_1151890202.4321@excelforum-nospam.com> wrote in message
news:FCC.2acik0_1151890202.4321@excelforum-nospam.com...
>
> 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
>

[FCC]

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