Excel VBA/Listbox Query

[TheRobster]

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

[RobDog888]

Maybe you can send an Escape keypress to cancel the edit mode of the cell in the ListBox1_GotFocus event.

[TheRobster]

That might work.

Um, how do I do that then?

Cheers
-Rob

[RobDog888]

Try the basic SendKeys. It is supported in VBA.

SendKeys "{ESC}"