Does anyone know how to resize the form window to fit the desktop ofany given resolution? Also, is it possible to dynamically add scrollbars(vertical, horizontal) to cover the form based on the resolution?
Look at the properties window in the development environment. There arescroll bars there.I don't think you can maximise a form. So you'll need to find the windowresolution and resize the form. The size of the underlying sheet can beretrieved (don't remember how, but a Google search will find it).
I think I found how to get the scrren resolution. Do you know what isthe vba code to have the form resized?
I think the form has width and height properties that you set, plus left andtop properties to position it - like all the other controls. All theinformation is available through the help and/or Google searches.
Thanks, I've found some code on google and tried it out. Works somewhat. It does enlarge based on the resolution but it doesn't lockin to the display like when you maximize a window but it works forme.Private Sub UserForm_Initialize()'Set the window size to maximumApplication.WindowState = xlMaximizedfrmVA.Width = Application.WidthfrmVA.Height = Application.Height