List box as a picklist

[E]

I have a document that we use to document medications. What I would like to
do ,is create a list box with the medications, then when the user double
clicks the list box the name of the medication populates another control in a
list.

I'm able to populate the list box and i nderstand how to assign the value of
the listbox to another control when double clicked. What I don't know is the
right control to assign the values to. I'd like to avoid using 23 (number of
meds) different text boxes and checking to see if they are null before
assigning a new value.

I hope this makes sense. Thanks for your help.

 

[Doug Robbins - Word MVP]

If your aim is to be able to select multiple medications, and then make use
of those items somewhere else, you might be better off using a multi-select
list box and build a string of the selected items and use that string to
populate one other control.

See the article "How to find out which Items are selected in a Multi-Select
ListBox" at:

http://www.word.mvps.org/FAQs/Userforms/GetMultiSelectValues.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[alborg]

I have a relatively new website specifically dedicated to helping fellow
physicians to program in VBA within Word to use Word as an EMR ("electronic
medical record"). You can freely download the program- WordEMRProject from
this URL: http://msofficeemrproject.com/Page2.htm. The tutorial that
accompanies it is here: http://msofficeemrproject.com/Page6.htm.

It uses 2 listboxes to select meds to print out drug lists, prescriptions,
etc.

Cheers,
Al