select different cell once "YES" is selected from a message box.

[danbates]

Hi,

I was wondering if anyone could help me please?

A part of my VBA code brings up a message box once cell J is entered.

Please Login or Register  to view this content.

What I would like is if the operator selects "Yes" then the curser moves 4 cells to the right, selecting the comment box.
If they select no then it just exits the message box.

Hope this make sense.

Kind Regards
Dan

[dflak]

Here is my take on it

Please Login or Register  to view this content.

[danbates]

Hi Dflak,

Apart from inserting a comment after moving right 4 spaces your code is perfect, thank you.

I can see now that was because of my brief description. I've deleted that part and now it is just what I was after.

So thank you again.

Kind Regards

Dan

[dflak]

The comments was the good part for me I had to look that up! I'm glad it works out for you.