asked on

Excel VBA - Show userform at the right top when activated

I have a form that pops up with a macro or upon initialzation.using the code

frmIntro.Show vbModeless

How can I make this come up in the upper right hand corner of the spreadsheet window?

Thanks, Eric

Jacques Geday

put this

frmIntro.Show vbModeless
frmIntro.left = 0
frmIntro.top=0

gowflow

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ekaplan323

ASKER

Gowflow,

Thanks, it works but you could just explain the code on line :
frmIntro.Left = ActiveWindow.Width - frmIntro.Width - 15
So that I can understand this for future applications

Thanks, Eric

sdwalker

He is seeing how wide the Excel window is and then subtracting the width of the form window. This would put your form at the extreme right edge of the window. He is then subtracting 15 more pixels so that it resides within the boundary of the Excel application.

At least that's how I see it.

sdwalker

ekaplan323

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for ekaplan323's comment http:/Q_27293237.html#36490229

for the following reason:

Simple solution that works

Jacques Geday

I gave you the solution and why on earth you accept your comment as a solution with zero points ??? Not that I am after points but I strictly do not get it !!!
gowflow

sdwalker

Me neither. That's nuts! Maybe he doesn't know what he did.

Jacques Geday

Well I objected to his closure It's the first time ever since I am member in EE !!!
:(
gowflow

Jacques Geday

ekaplan323
Sorry for my quick comment but I guess you closed the question wrongly. If yes and it is the case you need to click on the answer that you feel is the correct answer for you. If still you choose for your answer to be please explain as we do not understand. If you feel multiple answers get to be chosen then you click on each and you attribute points to each
gowflow

ekaplan323

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for ekaplan323's comment http:/Q_27293237.html#36490229
Assisted answer: 500 points for gowflow's comment http:/Q_27293237.html#36489440

for the following reason:

Great solution simple

Jacques Geday

I still don't get it !!! but it is beyond the scope of my intelligence !
gowflow

sdwalker

Question was correctly answered

ekaplan323

ASKER

Sorry for the misunderstaning, must have clicked the wrong button and I thought I corrected it by awarding the points to goflow. I guess that didn't quite do it huh

Jacques Geday

yes it didn't !
gowflow