Thread: [Solved] Data Input Form question
View Single Post
 
Old 04-01-2017, 02:52 AM
Cyberseeker Cyberseeker is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default

Quote:
Originally Posted by NoSparks View Post
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
Thanks, working well now. I get lost with 'initializing' and the such.
Reply With Quote