Userform Placement
I know you can indicate where to place an INPUTBOX, but can you do the same
for a userform? Thanks, Les |
Userform Placement
Hi,
Maybe Chip's FormPosition is what you need. http://www.cpearson.com/excel/FormPosition.htm Cheers Andy WLMPilot wrote: I know you can indicate where to place an INPUTBOX, but can you do the same for a userform? Thanks, Les -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Userform Placement
Thanks Andy,
I happen to find the following information that really helped. You can set the UserForm's Left and Top properties. But in order for these to be effective you need to set the StartUpPosition property to 0. Thanks again, Les "Andy Pope" wrote: Hi, Maybe Chip's FormPosition is what you need. http://www.cpearson.com/excel/FormPosition.htm Cheers Andy WLMPilot wrote: I know you can indicate where to place an INPUTBOX, but can you do the same for a userform? Thanks, Les -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 10:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com