Enable CommandButton after data selected in comboBox

[CR Anandan]

In Excel VBA , Pls help me code , on Open Workbook() disable CommandButton and when data selected in comboBox Enable command Button.

 

[vletm]

to Workbook1 - ThisWorkbook (Code)

Private Sub Workbook_Open()
    With UserForm1
        .CommandButton1.Visible = False
        .CommandButton2.Visible = False
'  next three lines for testing
        .ComboBox1.Clear
        .ComboBox1.AddItem "A"
        .Show
    End With
End Sub

to Workbook - UserForm1 (Code)

Private Sub ComboBox1_Change()
    With UserForm1
        .CommandButton1.Visible = True
        .CommandButton2.Visible = True
    End With
End Sub

Change Visible to Enabled, if You want to see buttons all the time.