VBA needed for message pop-up

excel forum help.xlsx

Hello,

I would like a pop up message when "Semi-Monthly" is selected from the dropdown list in cell B1. I can't seem to figure out the VBA by myself. I do not want the message permanently, only when one option is selected in B1.

Excel 2010

Do you need any more information?
Thank you very much!

Thanks a bunch, it worked great!

I am now getting an error when I try to fill data on this spreadsheet.
Run-time error '13':
Type mismatch

When I debug it highlights: If Target = Range("B1") Then

I take the file provided as an attachment in the second post of this thread. I put any number in cell D1. I use the fill handle to drag down any number of cells. Then I get the run time error pop up. I have not modified the worksheet other than inputting an integer in cell D1.

Please Login or Register  to view this content.

This is causing a problem for you because you have a range of cells selected, and excel can't compare a range of cells to a single cell. Target(1) will give you the first cell of the range, so replace your code with the code below, and it should work.

Please Login or Register  to view this content.

Thank you for the prompt reply. I used:

.Address

and I am not getting the error. Excellent forum. I'm glad I found it.