Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm truing to change the values in a drop-down list box selector, but the following generates a Runtime Error 424 on the ComboBox line(s).
Is is possible to do what I want? What is the correct syntax, please? __________________________________________________ ____________________ If Cells(5, 111).Value = "" Then p = Cells(2, 114).Value With WorkingSheet ComboBox3.ControlFormat.ListFillRange = Range(Cells(5, 112), Cells(p, 112)) End With GoTo Equipment Else p = Cells(2, 118).Value With WorkingSheet ComboBox3.ControlFormat.ListFillRange = Range(Cells(5, 112), Cells(p, 112)) End With End If _____________________________________ Thanks, Jim Berglund |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using VBA to retrieve values to ComboBox | Excel Discussion (Misc queries) | |||
Values of ComboBox fields and SQL | Excel Discussion (Misc queries) | |||
Entering Values into Combobox in Spreadsheet | Excel Discussion (Misc queries) | |||
Displaying Unique Values in a Combobox | Excel Programming | |||
ComboBox Values | Excel Programming |