• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Code needed to prevent data entry to a dependent list column temporarily

R

ronalgreen

New Member
I have a dependent drop down list that will allow data entry if the list it is dependent upon has not been chosen.


For example:


Column C50:C99 has the data that column D50:D99 are dependent upon. If nothing is chosen in column C, one can enter anything erroneous into column D. How can I prevent this while still using a drop down list and not a combobox?


Also, Column E50:E99 also are depedent upon column C50:C99 too and therefore have the same problem.


Any help would be greatly appreciated...
 
Good day ronalgreen


Why do you need VBA? Why not use the Error Alert with the Stop chosen in the pick window in the Data Validation window and give a message to indicate what is needed. This will stop them entering what you do not want.
 
Hi, ronalgreen!

If you consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the green sticky posts at this forums main page for uploading guidelines.

But just in case, have you gone thru this link?:

http://chandoo.org/forums/topic/data-validation-list-automatically-shows-the-first-item-in-the-list

Regards!
 
You must log in or register to reply here.
Back
Top