prompt to select from a list box

[bengalliboy]

I would appreciate if some one can help me. Thanks
I have got a command button, where I got a procedure that
needs to prompt user to select from a list and bring back to the list item selected. Some thing like this:

----
do some thing
do some thing
if not list1.listindex is selected
#go and select the list
show the list and wait
if the list is selected then
#come back with a value.
msgbox "You selected" & selected item

-----

My problem, from the command where make the listbox visible, does not wait or prompt user for a selection..

 

[dsi]

Where do you want to put the listbox? On an Excel worksheet, a Word document or on a VBA form? You'll need to provide a little more info for us to work with.