| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge and Center and Center Accross Selection | New Users to Excel | |||
| How do we Extract/Save a single worksheet out of a Mutlipage workb | Excel Discussion (Misc queries) | |||
| Center Across Selection Vertically Help. I am trying to center te. | Excel Discussion (Misc queries) | |||
| UserForm position other than center of the screen. | Excel Programming | |||
| textbox in userform(vertical center) | Excel Programming | |||
![Pierre via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
