Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using SetFocus with Frames
Hi
I have a UserForm with several text boxes embedded into frames (used only as a visual aid for grouping the text boxes). I am using AfterUpdate to validate the user input, eg: '--------------------------------------- Sub Txt_StartValue_AfterUpdate() Dim Msg, Title, Response If IsNumeric(Txt_StartValue.Value) = False Then Msg = "You must enter a number" Title = "Non-numeric Value" Response = MsgBox(Msg,16,Title) Txt_StartValue.SetFocus End If End Sub '----------------------------------------- Problem is, when Txt_StartValue is embedded within a Frame, the SetFocus doesn't work & the next textbox is selected. Any ideas as to how to get the correct textbox selected via the SetFocus? Thanks, James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) | Excel Discussion (Misc queries) | |||
Frames and buttons | Excel Programming | |||
freezing frames | Excel Worksheet Functions | |||
group/frames | Excel Programming | |||
Forms and Frames | Excel Programming |