Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
My problem is illustrated here with a form that contains a textbox and a spin button. The spin button updates the variable Mnth, sub FormRefresh updates the form with new values, and returns the focus to the text box.. However, focus isn't always returned to the text box, in fact it flip-flops between staying on the spin button and and returning to the text box.. If I insert a breakpoint or a message box anywhere in the loop, it works the way I expect it too, so I suspect this is a timing issue. However, inserting Waits or other delay tactics doesn't seem to fix it. Appreciate any suggestions, thanks. Regards, DaveU Private Sub spnDate_Change() Mnth = spnDate.Value Call FormRefresh End Sub Sub FormRefresh() ' ' code here that updates myForm according to Mnth value ' myForm.txtEntry.SetFocus End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spin Button | Excel Programming | |||
spin button value | Excel Discussion (Misc queries) | |||
spin button | Excel Programming | |||
Spin Button... | Excel Programming | |||
Spin Button | Excel Programming |