Workbook Open event

T

Todd Huttenstine

Hey guys, how do I add the value, in the code below ("Jan
Week 1") to combobox1 on sheet Pivot WOW REPS? The below
code is not working. I get an error.


Private Sub Workbook_Open()
ComboBox1.AddItem "Jan Week 1"
End sub

Thanks
Todd Huttenstine
 
J

Jim Rech

You have to tell VB what sheet the combobox is on:

Private Sub Workbook_Open()
Sheet1.ComboBox1.AddItem "Jan Week 1"
End Sub

Replace "Sheet1" with the code name of the correct worksheet.

--
Jim Rech
Excel MVP

| Hey guys, how do I add the value, in the code below ("Jan
| Week 1") to combobox1 on sheet Pivot WOW REPS? The below
| code is not working. I get an error.
|
|
| Private Sub Workbook_Open()
| ComboBox1.AddItem "Jan Week 1"
| End sub
|
| Thanks
| Todd Huttenstine
 
Top