Bob Phillips
12/11/2006 2:27:00 PM
All of the controls and the form itself have a Left, Top, Width and Height
property. You can adjust these within your code.
Example
Me.Height = 200 'changes the form height
Me.Controls("cmdOK").Left = 50 'changes the OK button's left position
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"simonc" <simonc@discussions.microsoft.com> wrote in message
news:32DDB783-0741-45D8-AF9A-09B9BE079060@microsoft.com...
> Is it possible to adapt the design of a user form (size of form, what
> items
> are displayed etc) based on decisions made earlier during running the
> macro?
> If so, how do you do this? Is there somewhere hidden in the code all the
> dimensions and positions of the different user form items, where you could
> base these on variables from elsewhere in the programme?
>
> Grateful for any help.