+ Reply to Thread
Results 1 to 4 of 4

Page Scrolling disables when userform activates and updates

  1. #1
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Page Scrolling disables when userform activates and updates

    I have a userform opens as modeless in the sheet selection change event
    Please Login or Register  to view this content.
    The image also changes as per the activecell.
    Now my problem is that I cannot scroll through the data area with mouse-wheel or Pageup/Pagedown and arrow keys. Can somebody suggest me a solution?
    Attached Files Attached Files
    Last edited by johnjohns; 05-02-2011 at 05:58 AM. Reason: attaching sample w.book
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Page Scrolling disables when userform activates and updates

    I'd prefer:

    Please Login or Register  to view this content.
    in the userform use:
    Please Login or Register  to view this content.
    But I think in your case you'd better off using pictures in the comments of each cell instead of using a userform.
    See the attachment for an illustration using some pictures from this forum.
    Attached Files Attached Files
    Last edited by snb; 05-02-2011 at 06:21 AM.



  3. #3
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Page Scrolling disables when userform activates and updates

    Thank you snb. I could insert pictures with following codes
    Please Login or Register  to view this content.
    and thru comments also as you advised. But still I would like to do it with userform and apply zooming also. Is there a way?

  4. #4
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Page Scrolling disables when userform activates and updates

    I am also ok with an answer "It is not Possible", if somebody confirms it.

    Bump no response

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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