| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Cell value form ListBox.
"Nigel" wrote: If the ListBox is on a UserForm then use the UserForm control change event to populate the currently selected cell and unload the UserForm. Code is in the UserForm Private Sub ListBox1_Change() ActiveCell = ListBox1.Value Unload Me End Sub -- Regards, Nigel "eme" wrote in message ... Thanks for your response Nigel, Sorry I was not clear, what I am looking for is the automatic Close/Cancel of the ListBox & UserForm after the selection is made. Something like ListBox.Close & UserForm.Close. I am migrating this VB code form Lotus.123 where it works fine. Thanks for the help Nigel, the bit that i was missing was the UNLOAD, all working now thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Listbox in a form | Excel Programming | |||
| listbox value to a form | Excel Programming | |||
| vb6 form with listbox | Excel Programming | |||
| listbox option in form | Excel Programming | |||
| Cell link in a form listbox - can it show a word? | Excel Programming | |||
Threaded Mode
