ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,832
- Office Version
- 2007
- Platform
- Windows
I am currently using the code shown below.
How would i go about making an edit so it not only works for Column A BUT also Row 6 then down the page.
Example If ActiveCell.Column = 1 & Row 5 or > Then
How would i go about making an edit so it not only works for Column A BUT also Row 6 then down the page.
Example If ActiveCell.Column = 1 & Row 5 or > Then
VBA Code:
Private Sub RepeatCustomer_Click()
If ActiveCell.Column = 1 Then
DatabaseRepeatCustomer.Show
Else
MsgBox "YOU NEED TO SELECT A CUSTOMER IN COLUMN A", vbCritical, "REPEAT CUSTOMER MESSAGE"
End If
End Sub