Hi all,
I'm using a Userform that requires the user to enter a bunch of information. In one of the textboxes, they must enter a certain code that they may or may not know. If they don't know the code they should be using, I want to set it so a new userform appears that gives them the options to select (It's a hierarchy type code selection process where each level selected give them a new set of items to select, kinda like ebay when you're selecting the category for a listing). So, the new userform that is opened will have 3 listboxes in it that I populate based on the selection in the previous list box. I'm all set there. But, what I need help with is how to open and use that new listbox without losing all of the information in the previous Userform. Can I keep the original Userform open and just open the new one if front of it? Or, can the original Userform just be pushed into the background while the user is making the selections? Then when the selection is made, the original userform comes back up will all the information already in it. Is this possible?
thanks for the help!
Bookmarks