| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I use VBA to set the value of an ActiveX ComboBox
:-( I'll do that then. Thanks!
"PCLIVE" wrote: In my first response, that method would be creating the ComboBox from the Control Toolbox toolbar. I think that may work better. "Harry F." wrote in message ... It's an ActiveX control....I didn't actually create them, but they are not from the Form Design menu. Would it be easier for me to recreate all of these this way? "PCLIVE" wrote: How did you create your ComboBox "DropDown1176"? "Harry F." wrote in message ... Now I get an error "Method or data member not found". "PCLIVE" wrote: Try this: Private Sub CheckBox6_Click() If CheckBox6.Value = True Then Me.DropDown1176.Value = a89 End If End Sub HTH, Paul "Harry F." wrote in message ... Hi, I have a form with several ActiveX Combo Boxes. I also have some check boxes. When one checkbox value is true, I want the combobox to default to a value, but when I put this code in, I get and "Object Not Defined" error message. Private Sub CheckBox6_Click() If CheckBox6.Value = True Then Worksheet.DropDown1176.Value = a89 End If End Sub Keep in mind I know Access VBA, but my Excel VBA skills are limited. Thanks, Harry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveX combobox | Excel Worksheet Functions | |||
| ActiveX Combobox and LinkedCell | Excel Worksheet Functions | |||
| publish activeX combobox and other activeX control | Excel Programming | |||
| How do I update contents of activeX combobox? | Excel Programming | |||
| HELP : ComboBox (Forms), Activex or What ? | Excel Programming | |||
Hybrid Mode
