Excel VBA/Listbox Query
 

Hi,

I have an ActiveX Listbox located in an Excel worksheet and I am using
it as a way to allow the user to select an item from the listbox and
then there is a table next to this which some VBA code copies different
data into depending on what item is selected in the list box.

The user can then edit the current data in the table by simply
selecting the relevant cell(s) and then manually entering new text or
figures.

The problem I am having is that if the user changes the data in the
table and the -doesn't press Enter/Return- before selecting another
item in the listbox, the code associated with the listbox doesn't run.

I would guess that the focus is still on the active cell because
Enter/Return has not been pressed. Is there any VBA code that I can use
that will get around this? I was thinking of something like "GetFocus"
to put the focus back on the listbox when an item is selected from it
but I can't get this to work.

Anyone here have any ideas?

Thanks
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=481873