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

Hello Bruce
If combo from the Tools Box, try this:
Sheet1.ComboBox1.Value = 3

HTH
Cordially
Pascal

"Bruce" <Bruce@discussions.microsoft.com> a écrit dans le message de
news:DE25DFD7-61B9-4261-AAB0-33E0E6F24BD7@microsoft.com...
> 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
>
>

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" <Bruce@discussions.microsoft.com> wrote in message
news:DE25DFD7-61B9-4261-AAB0-33E0E6F24BD7@microsoft.com...
> 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
>
>