ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   mutlipage in the center of userform (https://www.excelbanter.com/excel-programming/344722-mutlipage-center-userform.html)

Pierre via OfficeKB.com[_2_]

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

Bob Phillips[_6_]

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