Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i insert an interactive calendar in an excel form | Setting up and Configuration of Excel | |||
Inserting Interactive Excel Form into PowerPoint | Excel Discussion (Misc queries) | |||
Interactive user form design | Excel Programming | |||
Interactive Form | Excel Programming | |||
design form? | New Users to Excel |