Drop down list with pre selected value.

To solve the problem with the default value for your list simply enter the value that you want "Yes (Reccommended)" in the cell and then use data validation to create a list. Users will be able to select something different if they want.

Im not sure of exactly how to get a pop up box like you want but i suppose you could use some sort of conditional formatting?

Hope this helps

It's possible to input window....

untitled.JPG

But you can do that for values that aren't on validation list.
Don't know how to implement it for some values on validation list.

Originally Posted by zbor

It's possible to input window....

Attachment 51557

But you can do that for values that aren't on validation list.
Don't know how to implement it for some values on validation list.

Thanks, but not much of help I need this alert message when No is selected. I am not sure if this can be done using macro.

Further more help please!

Originally Posted by JBeaucaire

Right-click on the sheet-tab for this sheet and select VIEW CODE.

Paste in this sheet-event macro code in the window that appears:

Please Login or Register  to view this content.

Save your sheet and try changing values in the noted range.

NOTE: I would find this particularly irritating after awhile, I'm just saying. I might add a cell somewhere where I can indicate I "know" what I'm doing and not get those messages. Maybe like this:

Please Login or Register  to view this content.

This code looks fine, but I am facing an issue with this code, If I select a Few places with 'No' and at some time later I try clearing it by hitting delete key, I am getting "Runtime error 13 - Type Mismatch"

Whats wrong I dont know..

Help please.

Originally Posted by JBeaucaire

Please Login or Register  to view this content.

This looks perfect but could you help me on the Critical warning message, the message box is coming like a critical warning and not as a simple message box!

Thanks.

Originally Posted by JBeaucaire

Take out the vbCritical reference, then.

Thanks a ton for all your help! I have closed this post Cheers!