+ Reply to Thread
Results 1 to 19 of 19

Show userform next to active cell

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Show userform next to active cell

    Hi Guys,

    i tried to use this tool:

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

    but it does not work for me in 2 monitors. Why?
    Maybe somebody can help with it?

    what i want to achevie is:

    Screenshot_57.png

    to have useform form on the right from active cell, in my case is [E10].

    Why this is not working?

    The result what i got is:
    Screenshot_58.png

    code:
    Screenshot_59.png

    Please help with setting 2nd monitor...

    Please help,
    Jacek
    Attached Files Attached Files
    Last edited by jaryszek; 12-19-2020 at 07:22 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Show userform next to active cell

    You can get the range address of the shaped that was clicked.

    When your shape is clicked it will select the date cell then show the calendar userform

    Please Login or Register  to view this content.
    In the UserForm initialize event there is code at the end that will position the userform, you can play with the numbers to get the preferred position
    Please Login or Register  to view this content.
    Last edited by davesexcel; 12-20-2020 at 06:26 AM.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Hello,

    thank you. But it didnt work for me.

    Can you please delete attachment from post #2 --> i attached wrong example ( i mean i didnt want to use this example - this is a part of tool what i am doing and do not want to share to public).
    Sorry for that! My mistake.

    In screen you can see result after code changes proposed: - second screen on 2nd monitor:
    Screenshot_60.png

    In my main laptop monitor eveything works fine.

    Plus file in attachment--> please use this one.

    Best wishes,
    Jacek
    Attached Files Attached Files
    Last edited by jaryszek; 12-19-2020 at 07:38 AM.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Show userform next to active cell

    I removed the sample I supplied.
    Good luck in your endeavour.

  5. #5
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Thanks.

    Anyone can help with the issue?

    Jacek

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Show userform next to active cell

    I supplied the answer in post 2 and had supplied a sample workbook that you wanted removed.

  7. #7
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Yes,

    thank you.
    But it didnt work for me.
    Did you try solution on 2nd monitor?

    And another question: it will work when zoom is enabled ?

    Jacek

  8. #8
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Show userform next to active cell

    Second monitor should not be a factor since the code places the userform next to the activecell.

  9. #9
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Thanks.

    IT shouldnt but as i attached screen --> not working in my case. Maybe the size of monitor somehow has impact.
    And the problem still exists when you have zoom enabled...

    Jacek

  10. #10
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Show userform next to active cell

    Can you supply a sample using the code I provided in post 2,
    did you look at the code I had in that sample workbook you asked me to remove?

  11. #11
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Hi,

    yes, i added sample in post #3 with your code exactly.

    I am attaching once again.
    Please help and thank you for your support!

    Best
    Jacek
    Attached Files Attached Files

  12. #12
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Show userform next to active cell

    There are too many hidden rows. Unhide the rows and try the code again.

  13. #13
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Here you are:

    Screenshot_65.png

    Not working still.

    Jacek

  14. #14
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Plus on second monitor userform showed up on the center of first monitor, not in 2nd.
    Plus it doesnt work when zoom is enabled.
    I think that is not complete solution :/

    Jacek

  15. #15
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Show userform next to active cell

    I don't get a problem with second monitor.
    You are correct, the position does not work correctly with different zooms using my methods.

  16. #16
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Thanks davesexcel fro trying!

    Yes, this is why i think cpearson figured out the method to not use selected cells features but i do not know.
    On second monitor is working for you?

    Jacek

  17. #17
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    951

    Re: Show userform next to active cell

    jaryszek-I found a similar calendar type pop up calendar macro online (so I can't claim credit), which I applied in your workbook. It can be activated by double clicking on a cell or by clicking on the calendar icon. Not sure if this will work as you need it to or not, but worth a try.
    Attached Files Attached Files

  18. #18
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Hello lilsnoop,

    thanks! But this is just another userform - i need feature to show userform on the tight from active cell. Or specific cell.

    Jacek

  19. #19
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Show userform next to active cell

    Hello,

    anybody can help ?

    Jacek

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Show Userform Behind Active Windows
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-02-2021, 01:00 AM
  2. Hide ACTIVE WORKBOOK and show userform. Show ACTIVE WORKBOOK with cmdbutton.
    By angeliquep25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2017, 09:53 AM
  3. [SOLVED] Userform Launch - show userform when any cell in range on any worksheet is double clicked
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2016, 03:38 AM
  4. How to show a related Userform depending on the Active Cell value
    By chamdan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2010, 09:18 PM
  5. Show which cell, row, column that currently is active
    By a94andwi in forum Excel General
    Replies: 3
    Last Post: 06-29-2010, 12:00 PM
  6. Show active cells contains in other cell
    By KaLNaZ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2008, 05:53 PM
  7. [SOLVED] Only want color to show when cell is active
    By riccck in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2005, 07:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1