Multiselect Listbox w/Assoc Textboxes

[jfspsyd]

I was hoping for some suggestions with the following idea.

I have a multiselect listbox that loads a large list of medications.

For my purposes it would be great to have a textbox associated with each item selected from the listbox as well as a second associated textbox where medication dosage could be entered. So that fucntionally, each time that a new item is chosen from the listbox two new textboxes become visible, the first filled with the selected medication and the second is a blank textbox where medication dosage could be entered. I believe at this point that the the list box and associated textboxes would be on a user form that would be closed out and the information stored in the excel sheet.

I really dont have a good idea about how to accomplish this and would very much appreciate suggestions.

Thanks in advance.

 

[MickG]

Would it work if you had a List Box with 2 columns, One for the Medication
and the other for the Dosage.
The appropriate medication could be selected from the listbox, the Dosage entered in the Text Box and then either by a "CommandButton" or a TextBox "lost_focus" Event, Column (2) of the Listbox could recieve the Dosage amount from the TextBox.
You could do this for multiselect in the listBox, then the Total data required (Medication and Dosage) from the ListBox could be entered in the sheet.
Mick