separate events on sheet from events on userform

[davidmyers]

Hi,
I have userforms that open when I click in a cell - the userform has a listbox with terms to select for the cell.

The problem is that if the cell is in the same area that the userform occupies the same click opens the userform and selects a value from the list - how can I avoid this - I want 1 click to open the userform, and a separate click for events in the userform.

appreciate any suggestions

Thanks
David