Making a command button work!!!!

R

raw

Hello

I have a sheet with a combo boxes and a command button.

Is there a way that would make the command button work only when a
selection is made in a combo box

Eg combo box

Please select
Std
shaped finish
Shaped finish with trim

So if the bottom select is made (shaped finish with trim) the command
button when press will work. BUT if any of the other selections have
been made pressing of the button will have no effect?

The combo and command button are on a spreadsheet from the forms
toolbox

Thanks
 
N

Norman Jones

Hi Raw,

Try assigning the following macro to the combobox.

'============>>
Public Sub TesterX()
With ActiveSheet
.Buttons("Button 2").Enabled _
= .DropDowns("Drop Down 1").Value = 3
End With
End Sub
'<<============

Change the names of the combobox and button to accord with your scenario.
Change 3 to the required combobox selection number.
 
Top