I have a userform that will pull the data in from a sheet, but the sheet does not have named ranges. I am using header records instead (i.e. Main_Fruit). The problem I am coming up w/ is when I try to extend the dependent combo boxes to show specific data for the options chosen in the first two combo boxes (i.e. Main_Fruit_Colors, Main_Fruit_Kind). I need a way to have the first two combo boxes populate then have four more combo boxes populate w/ data based on the 2nd combo box. Right now it is set that the other 4 cbos populate based on the 1st cbo. Any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA - Userform - Pulling data into the userform by looking for a header record and not using a named range
- Thread starter slivesay
- Start date
