I have a workbook with 4 worksheets:- input sheet, clematis, climbers, evergreens. In clem clim and ever sheets there is a list of varieties that fit within that categary.
I have a userform on input sheet with two listboxes in it. The first listbox is populated with clematis, climber, evergreen. If I select clematis from the listbox I want listbox 2 to populate the numerous varieties from column c in the clematis sheet, and if select evergreen populate varieties from column c in the evergreen sheet etc etc.
I am not really sure what approach to take. I wasn't sure if an if else then approach was correct and if it was what the code would be or whether this was very sloppy and a better method exists.
Rather inexperienced but enthusiastic to learn.
Thanks in advance