Hi All,
I have tried to search for the answer but a lot of the solutions all show if there is an ambiguous selection made from a listbox.
I have a userform with several textboxes and 1 multi-select listbox (TestsRequired) which is populated from a rowsource in Sheet3 when someone changes the value in the combobox (TestHouse).
The issue I am having is if someone selects the value "Other (please specify)" from the TestsRequired listbox, a textbox (Other) becomes visible for the user to type in to.
When the user then presses the OK button, the values from all the textboxes and listbox all drop on to the userform with the TestsRequired values going down column M. This works great, but the textbox Other should drop on to column M next to the "Other (please specify)", but it either appears on to the first line of the listbox value, against all the listbox values or on some random row, not on the line Other (please specify).
Apologies if someone already has posted a thread about this as there are a lot, but I have been searching for weeks with no joy!
I have tried to search for the answer but a lot of the solutions all show if there is an ambiguous selection made from a listbox.
I have a userform with several textboxes and 1 multi-select listbox (TestsRequired) which is populated from a rowsource in Sheet3 when someone changes the value in the combobox (TestHouse).
The issue I am having is if someone selects the value "Other (please specify)" from the TestsRequired listbox, a textbox (Other) becomes visible for the user to type in to.
When the user then presses the OK button, the values from all the textboxes and listbox all drop on to the userform with the TestsRequired values going down column M. This works great, but the textbox Other should drop on to column M next to the "Other (please specify)", but it either appears on to the first line of the listbox value, against all the listbox values or on some random row, not on the line Other (please specify).
Apologies if someone already has posted a thread about this as there are a lot, but I have been searching for weeks with no joy!