hi. Pulling my hairout here. I know how to do a standard vba lookup but am trying to get a vlookup working based on value of textboxes and listboxes and defined ranges.
variety lst part is firing correctly, it seems to register the correct worksheet based on the categorylst selection made in the userform. My issue seems to be how to reference a named range. I have 4 clematisgen, climbergen, evergreengen and fuchsiagen.
these ranges are all defined on initialisation. I cannot seem to find a way to refer to these ranges using the selection in my category lst and adding "gen" to the end of it.
Any thoughts massively appreciated. Just cant see why it is not working.
Bookmarks