Hello Excel Geniuses',
I have a simple set of Text Boxes and when the User select the Clear button I want the curser to go back to Text Box 1, Any Samples?
Best Regards,Please Login or Register to view this content.
John
Hello Excel Geniuses',
I have a simple set of Text Boxes and when the User select the Clear button I want the curser to go back to Text Box 1, Any Samples?
Best Regards,Please Login or Register to view this content.
John
Last edited by JJFletcher; 10-10-2015 at 10:59 AM.
Hi there,
The following addition should work if your TextBoxes are located on a UserForm (i.e. not on a WorkSheet):
Hope this helps - please let me know how you get on.Please Login or Register to view this content.
Regards,
Greg M
P. S. Use TextBox1.Activate if the TextBoxes are located on a worksheet
Last edited by Greg M; 10-10-2015 at 10:35 AM. Reason: P. S. added
That worked perfectly - Great Solution...
Yes this is for a UserForm... On that note - The UserForm that I am using is attached here... It changes it's size from one computer to the next.. Any solutions for this effect?
ClassificationsV2.xlsm
Thanks so much!
Hi again,
Many thanks for your feedback - glad I was able to help.
As regards the UserForm changing size from one computer to another, the only thing that springs to mind is that the screen resolution on all of those computers might not be the same - sorry I can't think of anything else at the moment.
Best regards,
Greg M
Thanks for your feedback... Hopefully someone has a solution
Not much better than the above code
But darn useful if you have more textboxes.
Please Login or Register to view this content.
This will clear every single textbox
Please Login or Register to view this content.
Last edited by mehmetcik; 10-10-2015 at 11:46 AM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks mehmetcik,
I tried the code and works great... any thoughts on the Computer to Computer changes to the Userform.. Would like it to stick at one size fits all
Best Regards,
John
Hi again John,
Many thanks for the Reputation increase - much appreciated!
Best regards,
Greg M
My pleasure - and thanks again
Best Regards,
John
Is the userform size change affecting the layout of the controls?
Yes - the computer at my work the whole UserForm is smaller and I have to move stuff around
mehmetcik,
Thought I would ask you if you know of a solution for the All in one fits all UserForm issue.
John
Thanks for all the help
I think the common solution is to build userfoms in various sizes and choose one based on the monitor resolution, which you can query via Windows API.
That's a lot of work, though, and an alternative might be to make it as compact as possible, and adding a vertical scroll if necessary to make all of the controls accessible.
Entia non sunt multiplicanda sine necessitate
shg,
Thanks for your reply - I have been noticing that a lot of folks claim to have a solution, yet none of them have been successful..
I am afraid that your suggestion might be the Only Solution. This seems to be a long standing Issue... Maybe someone with VBA Savvy can finally figure a solution.
Best Regards,
John
You're welcome, good luck.
http://www.pcreview.co.uk/threads/us...uters.2783179/
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks