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. |
All times are GMT +1. The time now is 03:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com