Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform question
have 2 fields on a user form. when textbox1 is exited, it looks up the value
and stores it in a variable. if i don't find it, i pop a message box but i'm having a problem setting the focus back to textbox1. it always goes to textbox2 even thought i set focus back to textbox1. what's the best way to only go to textbox 2 if it finds the value entered into textbox1, otherwise clear textbox1 and set the focus. unloading and loading the form works, but just looking for a better way. -- Gary Keramidas Excel 2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform question
i just added
if me.textbox1.value = "" then me.textbox1.setfocus into a textbox2_enter procedure and it seems to work. any better ideas? -- Gary Keramidas Excel 2003 "Gary Keramidas" <GKeramidasAtMSN.com wrote in message ... have 2 fields on a user form. when textbox1 is exited, it looks up the value and stores it in a variable. if i don't find it, i pop a message box but i'm having a problem setting the focus back to textbox1. it always goes to textbox2 even thought i set focus back to textbox1. what's the best way to only go to textbox 2 if it finds the value entered into textbox1, otherwise clear textbox1 and set the focus. unloading and loading the form works, but just looking for a better way. -- Gary Keramidas Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Userform question. | Excel Discussion (Misc queries) | |||
userform question | Excel Programming | |||
UserForm Question | Excel Programming | |||
Userform Question | Excel Programming | |||
Userform question | Excel Programming |