.
Have I missed something regarding setting focus to a textbox ? The Command Me.TextBox1.SetFocus works in another part of my project (on UserForm1)
but it is not working on UserForm2 ... Me.TextBox4.SetFocus.
Any ideas ?
Please Login or Register to view this content.
.
Been messing around with the macro.
If I don't run the query ... but simply place the command Me.TextBox4.SetFocus into its own macro, it works.
So what is happening with the TextBox1 query part of the macro that is causing the SetFocus to fail ?
Hi Logit,
This is a bit vague, since many other factors may be at play in the remainder of your Code. Taking a long shot here, have you tried "Activate" instead of "SetFocus"?
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
.
Yup.
Look at the attached.
Also a second issue ... after running the query in UserForm2, I'd like the sheet to auto-scroll to the found row. Having difficulty getting it to do that as well.
Thanks Winon.
.
Finally located the issue with SetFocus to the desired TextBox.
TextBox3 was corrupted somehow. I deleted it from the UserForm and created a new textbox named TextBox3. The SetFocus now functions as desired.
I am still looking for a solution to have the sheet auto-scroll to the highlighted row where the query term is located - once it is found.
.
HA ! For the inquiring minds out there ... I found that answer as well.
This thread is now solved !Please Login or Register to view this content.
Thanks everybody !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks