Hello,
I am having issues figuring out how to populate a text box based off of a list box.
I have a list box for Ticket Type, then a list box to select a Category from based on the Ticket Type, and another list box to select a Sub Category from dependent on what Category was chosen. I need my text box to populate with text based off of the Sub Category selection.
I tried to do a vlookup based on the reference cell for the Sub Category list box, but because its only 1 - 5 it outputs the same information regardless of what Category I selected before selecting my Sub Category. And I need the user to be able to copy paste the text it outputs, so this just does not work.
I've been told I may need to use VBA to accomplish what I need to accomplish but I have no idea where to start. Does anyone have any suggestions?
I attached a scrubbed version of the workbook I'm trying to get working. Obviously all the sub-categories won't be the same in my actual work book ^^; Also featuring my failed attempt to get the vlookup to work as an option.
Bookmarks