open a userform next to the selected cell

[chibouki]

Hello,
I solve part of my calendar problem by integrating the calendar into a userform. But I would like the user form to open right next to the selected cell, here what I did:
- I set the StartUpPosition property at "0-Manual"
- I had some line these lines in the Sub UserForm_Initialize():

Please Login or Register  to view this content.

As result I got the UserForm that seems to follow some rules, but that is not at the proper location!!
Any idea what I did wrong?
Thx

[royUK]

This might help

http://cpearson.com/excel/FormPosition.htm

[chibouki]

yes it helps, my problem is solved,
thx,
D
ps: are you the only one who ever reply on this forum?!! Thx 4 your time.

[royUK]

yes it helps, my problem is solved,
thx,
D
ps: are you the only one who ever reply on this forum?!! Thx 4 your time.

No there's many helpers

[tygrrboi]

Many years later... but this code is not working for me. I have tried it both in the userform initialise as well as the module sub that calls the form to open

Am i doing it wrong?
Perhaps does this code not work with Excel for Mac?

[protonLeah]

@tygrrboi,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.