How to make a ComboBox select a specific value when i enter the workbook ?

[AlexCociorva]

Hi all,
I recently had a problem which put me in difficulty. I am developing an vbaexcel-based application which needs to select a specific ComboBox value from it's range each time I pass a start Form and enter the sheet (after introducing the username). The major problem is that my ComboBox won't receive that value in any way possible (i receive an error each time I write ComboBox.Value in the form, and/or workbook). I would be thankfull if any of you could help me on this one! I am looking forward for any suggestion at this problem !

Regards,
Alex

[Bob Phillips]

Post the code, or better the workbook with details on how we can replicate the problem.

[AlexCociorva]

Hello !

I have extracted a part from the main project and saved it into a separate excel file for explaining the problem. The attached file contains the ComboBox (in sheet1) with it's range values (from sheet2). In the VBA section (in workbook actions) I wrote the following code line:

[VBA]ComboBox2.Value="-Select product name-"[/VBA]

The problem is that i receive the following object error each time I open the workbook: "Runtime error 424: Object required". The same message i receive if i write the same code in the back of a form or different procedure, although is it valid in 'ComboBox2.Change' procedure.

Thank you !

[BrianMH]

[VBA]Private Sub Workbook_Open()
Sheets("sheet1").ComboBox2.Value = "-Select product name-"
End Sub

[/VBA]

You need to refer to the sheet in which the combobox resides.

[Bob Phillips]

This seems to do it

[vba]
Private Sub Workbook_Open()
Worksheets("Sheet1").ComboBox2.Value = "-Select product name-"
End Sub
[/vba]

[AlexCociorva]

It works perfectly! Thank you very much ! :-)