Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set the value of a combobox
I have a combobox that I want to set the value of as a default, but I get the
error 'Object doesn't support this property or method'. Any ideas on how to fix? Bruce Sub reset() Set Sheets("Sheet1").Shapes("ComboBox1").Value = 3 End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set the value of a combobox
Hello Bruce
If combo from the Tools Box, try this: Sheet1.ComboBox1.Value = 3 HTH Cordially Pascal "Bruce" a écrit dans le message de ... I have a combobox that I want to set the value of as a default, but I get the error 'Object doesn't support this property or method'. Any ideas on how to fix? Bruce Sub reset() Set Sheets("Sheet1").Shapes("ComboBox1").Value = 3 End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set the value of a combobox
Bruce,
Set is used to create an object variable. The value of a combobox is a property, so you do not use set. Which combobox type are you using? -- HTH Bob Phillips "Bruce" wrote in message ... I have a combobox that I want to set the value of as a default, but I get the error 'Object doesn't support this property or method'. Any ideas on how to fix? Bruce Sub reset() Set Sheets("Sheet1").Shapes("ComboBox1").Value = 3 End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Populating combobox from another combobox | Excel Programming | |||
Combobox | Excel Programming | |||
Combobox | Excel Programming |