I currently have:
Basically, when Cell B7 has nothing in it the Command Button is disabled but then when I type something back into it, it won't enable again.
How can I make it loop round so that it will enable again when I type something into B7.
Cheers for the help,
This forum has been so good I am looking forward to being good enough to help others!
Jeester
Code:
Private Sub CommandButton1_Click()
CommandButton1.Enabled = True
If Range("$B$7") = "" Then
CommandButton1.Enabled = False
Else
CommandButton1.Enabled = True
End If
ActiveWorkbook.Sheets(2).Activate
End Sub
Basically, when Cell B7 has nothing in it the Command Button is disabled but then when I type something back into it, it won't enable again.
How can I make it loop round so that it will enable again when I type something into B7.
Cheers for the help,
This forum has been so good I am looking forward to being good enough to help others!
Jeester
Last edited: