Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Window size setting
Is there a way with a UserForm to set the size dynamically on a users PC so
that the UserForm will take the full screen apart from the Windows related Start tab ? thanks Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Window size setting
Hi Scott
you could try checking out the solution to this sort of problem posted by Tom Ogilvy back in 2004 it is a very good approach to sort of problem as some of the other methods i tried before coming across Tom's post can lead to having to add a ton of code to move and resize your controls which depending on how much you have on your form can be a real pain in the a$$ http://groups.google.co.uk/group/mic...0e257060e8cb82 hope this helps you out Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Window size setting
Steve,
Thanks for that...I used that approach which allows for the screen resolution to be determined and then a different form shown. But the only way I could get it to work was to have a separate form and also separate procedures for validation of the form for each screen resolution. Is there anyway to parameterise a form name so that when calling a particular form based on the screen resolution a different collection is used.... at the moment I have things like..... VendorEntry_1280x1024.VendorFirstName = VendorEntry_1280x1024.VendorDataListBox.List(i, 0) VendorEntry_1280x1024.VendorLastName = VendorEntry_1280x1024.VendorDataListBox.List(i, 1) VendorEntry_1280x1024.VendorSalePropertyAddress = VendorEntry_1280x1024.VendorDataListBox.List(i, 2) Where the form has been set to the resolution.....is there a way to call a particular routine based on a different form ? SCott "Incidental" wrote: Hi Scott you could try checking out the solution to this sort of problem posted by Tom Ogilvy back in 2004 it is a very good approach to sort of problem as some of the other methods i tried before coming across Tom's post can lead to having to add a ton of code to move and resize your controls which depending on how much you have on your form can be a real pain in the a$$ http://groups.google.co.uk/group/mic...0e257060e8cb82 hope this helps you out Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the zoom size of a new window from 100% to 75% | Excel Discussion (Misc queries) | |||
Window setting | Setting up and Configuration of Excel | |||
how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
Duplicated code window and userform window problem | Excel Programming | |||
What is the setting to have more than one Excel Window? | Setting up and Configuration of Excel |