I have an excel list box working fine with the LOOKUP function to populate the required cells. What I am trying to do is if the first item is selected
"00.User defined"
a form will open to allow the user to enter the data required.

I have managed to get this working using the Worksheet_SelectionChange command. But using this function the command only runs after the focus has left the listbox cell (G3).

My question is;
Is there a way to trigger the VBA code (to open the form) when "00.User defined" is selected from the listbox in the excel worksheet (while the cell containing the listbox still has the focus)?

Thanks for any help you can give me.