Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
this is in a worksheet_open sub. the combobox is the only activex
control on the worksheet. what am i doing wrong? i tried "value" but that didn't work. but neither is listindex. i originally had it all in one line but when that didn't work i thought it might need a "with" statement (ThisWorkbook.Sheets("Income").OLEObjects ("cmbCounty").ListIndex = 0 'Value = "") thanks a lot for any advice. With ThisWorkbook.Sheets("Income") .OLEObjects("cmbCounty").ListIndex = 0 'Value = "" End With :) susan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combobox value blank | Excel Programming | |||
Reset values in a combobox | Excel Programming | |||
Combobox drops down blank row | Excel Programming | |||
reset a combobox | New Users to Excel | |||
Remove blank rows from combobox | Excel Programming |