Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: Display a message when one of the names is displayed in a ra
Hi All,
How can I display a message box if a range (B1:B10) has one of these values (tom,ross,chad,sam,josh,jill) on a button click (DisplayMessage) Here is what I have so far but I get a type mismatch error: Sub DisplayMessage_Click() If Worksheets("Sheet1").Range("B1:B10) = "tom" or "ross" or "chad" or "sam" or "josh" or "jill") Then MsgBox ("Name present") End If End sub Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to 'put' calc displayed in message box in cells | Excel Discussion (Misc queries) | |||
macro runs fine but error message is displayed | Excel Programming | |||
how can I have a message displayed when a spreedsheet is opened ? | Excel Discussion (Misc queries) | |||
Display a form prior to workbook being displayed | Excel Programming | |||
No message box displayed | Excel Discussion (Misc queries) |