Macro for drop down menu based message box

[aneshdas]

Friends,

Good day to everyone !

I need a macro code for the following problem.

I have an excel sheet and on that I am using drop down menu in Cell U8 to U357 (Data Validation). In this work sheet, If I selected the value "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.

Eg: As soon as I selected "A" from drop down menu in cell U10, the " Please enter the absent mode" message should appear with an OK button and after clicking the OK the cursor should select the "V10" Cell where the absent mode has to enter. I will be more happy if only the "V10" cell is active and the user can do anything in other cells Only after entering any value in the "V10" cell.

Kindly help me with a macro for this and thanks in advance.

 

[dermie_72]

Hi Aneshdas,

Welcome to the forum. You have entered a request in the Excel Question section of the forum. Your post doesn't seem to be a question, more of a request for someone to write you a macro. Maybe I have misunderstood, or it could be a translation issue.

Do you have a question about Excel, or maybe you have written part of a macro that you can't seem to get working, and would like assistance on?

If however, you're not very fluent in the VBA language and no one on the site has provided you with a specific answer, I can highly recommend any of the visual basic books that are advertised on this site. They will certainly benefit you, not only for this query, but for many queries you may have in the future.

Should you have any additional questions, do not forget to post your code along with your question.

Best regard.

 

[aneshdas]

Hi Aneshdas,

Welcome to the forum. You have entered a request in the Excel Question section of the forum. Your post doesn't seem to be a question, more of a request for someone to write you a macro. Maybe I have misunderstood, or it could be a translation issue.

Do you have a question about Excel, or maybe you have written part of a macro that you can't seem to get working, and would like assistance on?

If however, you're not very fluent in the VBA language and no one on the site has provided you with a specific answer, I can highly recommend any of the visual basic books that are advertised on this site. They will certainly benefit you, not only for this query, but for many queries you may have in the future.

Should you have any additional questions, do not forget to post your code along with your question.

Best regard.

I am extremely sorry for the confusion sir.

i am requesting for a macro for the above calculation.

 

[BrianMH]

Aneshdas I notice that you crossposted at the below link. It appears a solution has been provided. I notice you haven't replied to xld. Can you please reply to both threads if this has now been solved.

Macro for drop down menu based message box

Thanks