Macro to Create Message box based on cell values

Friends,

I have an excel sheet and on that I am using drop down menu from Cell U8 to U357 (Data Validation). In this work sheet, If I selected "A" from the drop down menu, I want to Display a message box with a message " Please enter the absent mode" and once the user clicked OK on the message box automatically the selection should go to its parallel "V" cell. (If only that cell

Eg: As soon as I selected "A" in U10, the " Please enter the absent mode" message should appear with an OK button and after clicking the OK the curson should select the "V10" Cell. I will be more happy if only "V10" cell is active and only after entering a value in "V10" then only the user do anything on other cells.

Kindly help and thanks in advance.

But Sir, I need the message box to appear only if I I selected the values in between Cell U8 to U357....and how about the selection after clicking the OK button in the message box?

Originally Posted by davesexcel

Copy and paste this code in the Worksheet Module

Please Login or Register  to view this content.

Sir,

Thanks

It is working, But how about going to respective next cell after clicking OK????

Originally Posted by davesexcel

Copy and paste this code in the Worksheet Module

Please Login or Register  to view this content.

Sir,

Thanks

It is working, But how about going to respective next cell after clicking OK????

Originally Posted by davesexcel

If you select "A" from the dropdown, the cell next to it is automatically selected. even before the msgbox pops up.

Sir,

it is working. It has just selected the cell. But there is a drop down menu on that cell too. I mean to say I need to activate the drop down menu in the respective 'V" cell as soon as I selected the "A" in the "U" cell along with the message box.

Hope you can sort out this too..

Thanks for your help sir.

Sir,

I hereby attached the sample work sheet. Only password I used on that workbook is 'master'.

Also plz let me know how i can do the serial number in the "unauthorised list" page. since it will hide automatically the rows which are not absent. I need the continues numbers in the absentees list, except count the hiden rows.

plz have a look in to this workbook and provide me your valuable advices for all the possible changes which can make the work sheet more accurateand attractive. also plz provide me more macros to beautify the workbook.

Thanks in advance sir.

sir,

Hope you got the sample file. Kindly update me.

sir,

I dont know why you cannot open the same. "master" is the password I used for VBA too....Do you want me to send that again. I can open the same file here..

Originally Posted by davesexcel

I can't open your VBA project.
Your sample should only reflect what you are asking

Plz check this sample file. hope you can open this file. Pasword used on this is "master".