MsgBox

[braydon16]

I'm hoping to get some simple code to use for a worksheet. I have some cells I'm asking a user to input data into, and once the data has been input, I'd like it to trigger a message box letting them know the illustrated results are located on sheet 2. I can create the message box easy enough, but the select case language is giving me trouble.

It's only for one worksheet in the workbook, and I would need the messagebox to pop up only when they've entered data in cells H25 and/or J17 (essentially, I understand it to be a change event, I just can't figure it out).

Please help!

[Andrew-R]

The code needs to go into the workbook change event, but in there you can just check the row and column of the Target, which is passed into the event anyway, e.g.

Please Login or Register  to view this content.

[homasa]

well, i probably am messing things up but perhaps something like this would work:

Please Login or Register  to view this content.

[mojo249]

In either event (H25 and/or J17), the cell J17 needs to be entered, so you only need to code for that:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Try

Please Login or Register  to view this content.

HTH

[braydon16]

Thank you!