Pop-up msg box action

Hi,

I have have written some VBA code and attached it to a text box saying PRINT.

When the button is pressed a pop-up should come up saying Warning! Have you created a unique reference. This then has yes and no buttons. If the user clicks yes the sheet should print, if the user clicks no, the cell "I3" should be selected and highlighted yellow. I have got the code to work but it also turns the cell that was previously selected yellow, any help?

This is what I have so far:

Please Login or Register  to view this content.

Thanks

Try something like this:

Please Login or Register  to view this content.

Dom

Your code to turn the cell yellow is not in the If statement so you could try this version:

Please Login or Register  to view this content.

As ncmay says your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Edited this time only