View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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