UserForm changing size from one computer to another

[JJFletcher]

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?

Please Login or Register  to view this content.

Best Regards,

John

[Greg M]

Hi there,

The following addition should work if your TextBoxes are located on a UserForm (i.e. not on a WorkSheet):

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M


P. S. Use TextBox1.Activate if the TextBoxes are located on a worksheet

[JJFletcher]

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!

[Greg M]

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

[JJFletcher]

Thanks for your feedback... Hopefully someone has a solution

[mehmetcik]

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.

[JJFletcher]

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

[Greg M]

Hi again John,

Many thanks for the Reputation increase - much appreciated!

Best regards,

Greg M

[JJFletcher]

My pleasure - and thanks again

Best Regards,

John

[mehmetcik]

Is the userform size change affecting the layout of the controls?

[JJFletcher]

Yes - the computer at my work the whole UserForm is smaller and I have to move stuff around

[JJFletcher]

mehmetcik,

Thought I would ask you if you know of a solution for the All in one fits all UserForm issue.

John

[JJFletcher]

Thanks for all the help

[shg]

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.

[JJFletcher]

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

[shg]

You're welcome, good luck.

[mehmetcik]

http://www.pcreview.co.uk/threads/us...uters.2783179/

Please Login or Register  to view this content.