Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a combobox ( named "ddCity" ) placed on the first page of a
worksheet. On the Activate event of ANY other worksheet, I want to display a polite message indicating they need to choose a city, first. How do I reference the combobox? Something like... If isnull(Worksheets("Main").ComboBox("ddCity").value ) = True Then MsgBox "Please Choose A City." Worksheets("Main").ComboBox("ddCity").Select Exit Sub End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn off page reference in page break preview | Excel Discussion (Misc queries) | |||
How To Reference What Is In A ComboBox In A Cell Formulas??? | Excel Worksheet Functions | |||
How do I copy a combobox to many cells with relative reference? | Excel Discussion (Misc queries) | |||
Add a combobox to an Excel spreadsheet and reference value in VBA | Excel Programming | |||
how to put a reference from a page of a multipage form to another page | Excel Programming |