I'm very new to Excel and haven't done any VBA since Office 2003 so keep in mind I'm a nub...
Here is my dilemma:
I have a spreadsheet that list states, counties, and their appropriate windspeeds and ice as the example below shows:
Spreadsheet.pngI want to create a userform that will sort the states with a combobox then populate a second combobox with the counties from that state. Once the county is selected I have a Command Button to then fill Text Boxes with the appropriate information from the Comboboxes filter. I have been able to gather a few code samples that would seem to work but I’m having trouble piecing them together and getting it to work.
Below is a picture of the Userform so far, if anyone has any advice on how to get the information from the spreadsheet above to populate the Userform below using the method described above I would really appreciate it. Thanks in advance
Userform.JPG