View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Interactive user form design

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" wrote in message
...
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.