Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Bandit, if you're talking about a userform, follow these steps:
1. Display the userform in the VBA editor 2. Display the userform properties. 3. In the userform properties, set Startup Position to manual. 4. Copy this code and paste to your userform module: Private Sub UserForm_Initialize() Me.Left = Application.Width / 2 - Me.Width / 2 Me.Top = Application.Height / 2 - Me.Height / 2 End Sub James Bandit wrote: I have a custom dialog box with dropdrowns etc used to select options. Each time you click the command buttion that shows the dialog box the box moves towards the upper left corner of the worksheet? How can I center the dialog each time it is shown?. Are there methods to control the position of a dialog using VBA or other means? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Properties dialog box opens instead of a workbook | Excel Discussion (Misc queries) | |||
When opening a workbook, need to ensure user opens in a certain ce | Excel Discussion (Misc queries) | |||
Center text in dialog box | Excel Worksheet Functions | |||
using Windows API Open Dialog/Browse in VBA - center form in scree | Excel Programming | |||
How can I program a message box to open when a user opens and exc. | Excel Programming |