I have a text box (empl_no2) in my userform. If the user enters an inappropriate value, I want error to code to reset the default value ("00000") and then highlight it to allow the user to overwrite it.
This has worked for me in the past, but for some reason this time it's not. It isn't highlighting the text.
Please Login or Register to view this content.
Last edited by Jenn68; 02-28-2019 at 09:28 PM.
How about this..
Please Login or Register to view this content.Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
This codes works for me. What module has this code? What sub? Do you see the MsgBox?
In cases like this, people often trace an error to the wrong place and so they post something very narrowly focused, we scratch our heads over it, later realizing the problem was somewhere else entirely. Consider attaching your file, with private data removed. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Thank you both for your support,
Bakerman, I have intentions of tring out your suggestion, I just haven't yet as from posting the whole module, as Jeff mentioned, there may be more to the problem than what was simply posted originally.
Here is the entire module ... (yes, I'm certain it can be streamlined, and perhaps Bakerman's suggestion is all emcompassing)
It will take me considerable time to sterilize my application to provide publically. Perhaps with the whole module being posted the problem is more visible and posting the file will be unnecessary. And yes ... I do see the msgbox.Please Login or Register to view this content.
I will continue to look at this but have reproduced your problem. Even though focus is set to the textbox, as soon as the Sub exits, focus shifted to my Close button even though there is no code to do that.
Jeff, I think I've experienced that behaviour in the past and my best guess it's the AfterUpdate -event that's responsible for that.
AfterUpdate already moves the focus, so the code will be executed but the SetFocus of the textbox is overridden by the AfterUpdate.
Excellent observation. When using the Exit event (and setting Cancel to True) this works perfectly.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks