Add TextBox for each item checked in ListBox

Hi,

I am not married to any solution, so I will explain what I am trying to accomplish and what I currently have (which is not much). I am creating a form for vendors to fill out. In a previous userform the vendor will input item information. The number of items is variable and will change each time a new form is created.

In this screen I need for the vendor to be able to see and select each of the items with a checkbox. Then if an item is checked I need a textbox to appear next to it for them to input the number of the selected items needed.

All I have currently is code to make the list appear in the listbox:

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Hi Norie,

thanks for responding so quickly.

I am completely open to the first idea, however will this work if they need to select multiple items (and I did not mention this previously so apologies).

For the second option, which as you say, sounds more like what I am imagining, will I need to create a hidden textbox for each potential item in the userform object or can that be done in the code if the item is selected?

I guess my real question is, would option 1 be possible for multiple items in the same userform? The vendor is going to have to perform this action a certain number of times based on a previous number they entered. For example the vendor has 10 items that need to go on 4 shelves. I would like for the vendor to see this userform 4 times wherein they would check which items will go on that shelf and then next to each checked item a textbox for them to enter the quantity.

Since they will be seeing multiple userforms already, I would like to limit that number as much as possible for ease of use purposes.

Unfortunately I can't upload anything save code due to corporate policy. However I will try to more thoroughly explain how the vendor gets to the point where I would need my initial request.

Vendor runs macros. Userform1 appears and vendor populates textboxes with generic vendor information (name etc) that is transferred to a standard form outlined in created worksheet. After Userform1 closes Userform2 opens and collects display information. After Userform2 closes Userform3 opens and the vendor inputs number of items in display. After Userform3 closes Userform4 opens X amount of times where X is the number entered into Userform3). If certain conditions are met from Userform1 and Userform2 then Userform5 opens asking the vendor how many shelves. That is where I currently am.

I would like Userform6 to include a listbox of all of the items entered by the vendor in Userform4. When they put a check next to the item it opens a textbox for them to input the quantity. I would like them to be able to check multiple items in Userform6 with multiple textboxes. I then need Userform6 to open X amount of times based on the response to Userform5 (i.e. once for each shelf).

Does that help? I apologize for my limitations and any confusion, and I appreciate your taking the time to consider.

I think I am getting close but textbox is not becoming visible when the item is selected from the Listbox. It works if I put it in CommandButton but not under ListBox click. Here is the code I have so far:

Please Login or Register  to view this content.

Any help crossing the finish line would be greatly appreciated.

I have only been writing vba code for 5 days, so I don't know what that is or how to do it.

But I reset my thinking and tried to set it up as checkboxes instead of a listbox with checks. I think this will work better for the latter functionality if I can get the textboxes to become visible. The problem I am seeing is that I cannot set up a Click procedure sub on the checkboxes that I am creating because those are being created in the userform_initialize sub

Please Login or Register  to view this content.

Everything in the Checkbox_Click sub portion of the code above does not work because it is not tied to a specific checkbox...