Code Issues: Validation Code does not register new entry until it is ran once

[jaredmccullough]

I have the following code which creates a validation in cell E12 of a worksheet.

Please Login or Register  to view this content.

My problem is I use a Userform to create new rows from the list it is pulling in. When I use the userform to enter a new row in the datasheet it is not pulling the newly entered row (cell A of the row) into the validation until I run the validation one time then when I open up the dropdown list the new entry will be there.

Any inclination of why this is?

thanks for any help

[davesexcel]

Can you set the validation in your UserForm?
The worksheet_Change event will only kick in when you change E12

[jaredmccullough]

Dave,

I will try my best to explain. The userform say "Userform1" for the sake of discussion is used to populate data in a background spreadsheet called "Variance Database" (as referred to in the code). The validation itself is on a separate worksheet called "Report" which is a custom report which uses VLookups of the "Variance Database" based upon the E12 value. So if you can picture it when E12 changes the whole report changes. So I would be inclined to say that the validation is an independent function of the userform.

I would like to inquire if there is any loop hole. Say when you click on the validation it changes real quick without the user recognizing or when the worksheet itself is activated it changes or any kind of technique like that?