![]() |
mutlipage in the center of userform
Hi Experts,
I have a userform that fills the screen. On the userform i have a multipage. I would like the multipage centered on the userform.... I do not know how to do that in VBA. Could anybody please help me ? thanks, Pierre -- Message posted via http://www.officekb.com |
mutlipage in the center of userform
Pierre,
Add this activate code into your userform Private Sub UserForm_Activate() With Me MultiPage1.Left = (.Width - MultiPage1.Width) / 2 MultiPage1.Top = (.Height - MultiPage1.Height) / 2 End With End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:56d8fc08bc1fe@uwe... Hi Experts, I have a userform that fills the screen. On the userform i have a multipage. I would like the multipage centered on the userform.... I do not know how to do that in VBA. Could anybody please help me ? thanks, Pierre -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 06:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com