| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Populate Combo Box When Opening a Worksheet
Somebody PLEASE help me figure out how to autopopulate a combobox (the
control, not form) when opening an Excel sheet. I literally just want to fill the cboBox with a set of text values automatically when opening the document. This should be simple, right??? Thanks, Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto Populate Combo Box When Opening a Worksheet
Try something like the following. It MUST be in the ThisWorkbook code
module: Private Sub Workbook_Open() With Me.Worksheets("Sheet1").ComboBox1 .AddItem "Cindy" .AddItem "Kathy" .AddItem "Sandy" .ListIndex = 0 End With End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) wrote in message ups.com... Somebody PLEASE help me figure out how to autopopulate a combobox (the control, not form) when opening an Excel sheet. I literally just want to fill the cboBox with a set of text values automatically when opening the document. This should be simple, right??? Thanks, Steve |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto Populate Combo Box When Opening a Worksheet
On Jul 2, 2:08 pm, "Chip Pearson" wrote:
Try something like the following. It MUST be in the ThisWorkbook code module: Private Sub Workbook_Open() With Me.Worksheets("Sheet1").ComboBox1 .AddItem "Cindy" .AddItem "Kathy" .AddItem "Sandy" .ListIndex = 0 End With End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consultingwww.cpearson.com (email on the web site) wrote in message ups.com... Somebody PLEASE help me figure out how to autopopulate a combobox (the control, not form) when opening an Excel sheet. I literally just want to fill the cboBox with a set of text values automatically when opening the document. This should be simple, right??? Thanks, Steve Perfect! Thanks Chip - really appreciate the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looking for a function that will populate opening a worksheet or t | Excel Worksheet Functions | |||
| Auto populate one worksheet from other worksheets | Excel Worksheet Functions | |||
| using a worksheet range to populate a combo box in excel | Excel Programming | |||
| Best way to populate worksheet from 2 combo boxes | Excel Worksheet Functions | |||
| Populate a combo box from a worksheet with VBA | Excel Programming | |||
Linear Mode
