Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to set the RowSource for a ComboBox based on a condition?
For ComboBox1 I would like to set the RowSource as follows: If ActiveWorkbook.Worksheets("FR Launch Sheet").Range("B3") = Sat then Rowsource would be 'Routes'!$E$2:$E$61 If ActiveWorkbook.Worksheets("FR Launch Sheet").Range("B3") = Sun then Rowsource would be 'Routes'!$H$2:$H$61 If ActiveWorkbook.Worksheets("FR Launch Sheet").Range("B3") did not equal Sat or Sun then Rowsource would be 'Routes'!$B$2:$B$61 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
RowSource as a row | Excel Programming | |||
XLA and Listbox.rowsource | Excel Programming | |||
RowSource | Excel Programming | |||
help with rowsource | Excel Programming | |||
Using IF, Then with rowsource? | Excel Programming |