Making a command button work!!!!

  • Thread starter Thread starter raw
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Microsoft access database(creating a search engine form) 0
Access How Current page of a form Read Only 2
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Shape Arrays VBA 0
How to make an image into a command button? 3
Combo box - Refreshed on condition 1
Command Button 2
option button groups interact with eachother 1

Back
Top