lexluther88
11-12-2006, 01:51 PM
First, the code will check to see if the ActiveCell selected is in the second column that contains the product names - column 2. If the column is not 2, show a message box with title "Error" and message "You need to select a product in the second column." Also, have the code quit out of the subprocedure after showing the message.
I'm trying this:
If ActiveCell.Value <> Cell(2) Then
msgBox "You need to select a product in the second colum", "Error"
End If
How can I a code to quit out of the subprocedure after showing the message. Also is "<>" the symbol used for "not equal to?" I checked online, and as simple as it seems, nothing has given me an answer for a not equal to sign...
Any help would be appreciated, thanks!
I'm trying this:
If ActiveCell.Value <> Cell(2) Then
msgBox "You need to select a product in the second colum", "Error"
End If
How can I a code to quit out of the subprocedure after showing the message. Also is "<>" the symbol used for "not equal to?" I checked online, and as simple as it seems, nothing has given me an answer for a not equal to sign...
Any help would be appreciated, thanks!