Hi all, have a combobox called (combobox1) on a worksheet. (sheet2) Linked cell is D4
My issue is that I have code in lost focus event which is bugging out because when user makes selection from combobox using dropdown arrow then using mouse tries to move to another sheet. My codes assumes they would tab down to next cell on same sheet. What I want is a way for selection to be made in combobox and automatically move focus away from combobox to cell D5, then if user tries to move to another sheet the code in lostfocus event has triggered, which it does nicely when they click into cell D5 now.
Hope this is clear, any help greatly appreciated.