It appears to me the Order sheet column B has pretty much the same stuff.
Not knowing how you use the file have to wonder if the userform shouldn't be writing to there.
Your Auto_Open sub populates AC11:AC16 from U11:U16
Removed the ControlSource and RowSource from the text/combo box properties
Set default property of Submit button to false
Populate Country combo at Userform_Initialize
Populate State combo from County_Change
Submit button writes to next row on GrpRecords sheet, same as previous, now also writes to Calcs U11:U16
Don't think anything else changed
|