form controls and macros

[dilleyo725]

Hi,

I'm trying to implement a combo box with a "yes" and "no" option. What I'd like to do is have a macro run if the "yes" drop down was selected. The macro would simply unhide some additional rows to allow the user to complete more information.

I'm not too savvy with combo boxes and my experience with macros is limited. I just created the macro using the record button and assigned it but I need it to run ONLY for the yes option. How do I do that?

thanks!

 

[onlyadrafter]

Hello,

can you change the Combobox to DATA VALIDATION?

If so, the code could be run on a WORKSHEET_CHANGE event.

 

[dilleyo725]

that's a good idea. But I'm not familiar on how to create/run code on a worksheet change event. Would you be able to walk me through that? Or point me in the right direction?

thanks again.

 

[onlyadrafter]

Hello,

In your spreadsheet, right click the mouse over the relevant sheet tab, and select VIEW CODE. Paste the following code into the new window

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$1" Then
        If Target.Value = "YES" Then
            'your code here
        End If
    End If
End Sub

change A1 to your cell, and add code as required.

am about to go home, any problems, there are many people who can help.