Hello, everyone! Hoping you all can help me on this...
I am working on a database for my company, and the users need to be able to enter new categories and subcategories for things. Right now I have a userform set up where they can type a new category name into a textbox, press a button and add the item to a listbox called "Sub1List". The problem is that now I want to take the category names they have entered in the listbox and place each of them into an individual textbox on the next page of the userform. The items will serve as headers at this point, and the user will have the opportunity to enter subcategory items beneath that category name.
I figured I could name each of these future textbox homes "Sub1Title(i)", find the ListCount number for each list item, match the ListCount number to the textbox number, and populate the value after that. I've done matching numbers like this for numerous other projects and it works really well for me. The issue is that I can't even figure out how to return the list item values without selecting them, and I REALLY don't want to select every single item in the list in order to get the value in the right spot.
Since I really have no idea how to do this, I have no example code. Any suggestions?
Bookmarks