tony.reynolds
Board Regular
- Joined
- Jul 8, 2010
- Messages
- 97
I have an annoying one where i have a multipage and two tabs
I have series of textbox1-textbox12 on the tab 0 that the 'on enter code' changes the listbox.value on tab 1 to the same value and selects the tab
Only trouble is wherever the mouse pionter is when i enter with a left click it changes to the value under it
when i right click or enter via tab key it selects the right one
Ive also tried
Iv also tried Application.screenupdating = False but thatdoesnt help
Can someone help me get around this?
I have series of textbox1-textbox12 on the tab 0 that the 'on enter code' changes the listbox.value on tab 1 to the same value and selects the tab
Code:
Private Sub FindOrderDescription1_Enter()
OrderStockerTabs.Value = 2
SearchPartDescription = FindOrderDescription1
End Sub
Only trouble is wherever the mouse pionter is when i enter with a left click it changes to the value under it
when i right click or enter via tab key it selects the right one
Ive also tried
Code:
Private Sub FindOrderDescription1_Enter()
SearchPartDescription= FindOrderDescription1
OrderStockerTabs.Value = 2
End Sub
Iv also tried Application.screenupdating = False but thatdoesnt help
Can someone help me get around this?