vw412
Active Member
- Joined
- Dec 16, 2011
- Messages
- 385
- Office Version
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
I have a worksheet with two TextBoxes and two ListBoxes. Normal user interaction would be for a user the click in TextBox1, key some info which will update Listbox1 using the TextBox1_Change event. Once the item the user wants shows in the Listbox he is to click on it to perform a function. This all works well. What I need to do is to capture the abnormal occurrence when a user clicks in the TextBox1 then chooses to click into the sheet rather than the ListBox. I have traced all the events involved except a possible event when the user clicks into the sheet instead of the ListBox. Any thoughts or discussion?