+ Reply to Thread
Results 1 to 3 of 3

Navigate in worksheets in excel form

  1. #1
    Registered User
    Join Date
    11-18-2013
    Location
    Zurich, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    54

    Navigate in worksheets in excel form

    Hi,

    I have created a user-form in excel 2010 and I want the user to switch between sheets and actually look at them.
    It is easy to choose and see a sheet from a form but the sheet is locked and you can only see the top left portion.
    Is there a way to unlock it or use scroll-bars for the sheets?

    Thanks

  2. #2
    Registered User
    Join Date
    11-18-2013
    Location
    Zurich, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Navigate in worksheets in excel form

    So, it's not actually possible to unlock the sheets while in "form mode"? One way to solve this is to use buttons
    to select other cells (perhaps using offset). But that should be the last resort...

  3. #3
    Registered User
    Join Date
    11-18-2013
    Location
    Zurich, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Navigate in worksheets in excel form

    For anyone interested, I found an easy solution.
    UserForm1.Show vbModeless and you can use the worksheet as you wish.

+ 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. navigate between worksheets
    By T. Grindlay in forum Excel General
    Replies: 10
    Last Post: 02-08-2012, 07:39 AM
  2. Navigate to IE form Excel
    By rkb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2011, 09:29 AM
  3. Create form to navigate report pages
    By usafmeinweg in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2010, 06:22 PM
  4. How to navigate in MultiPage1 control of Excel form?
    By surotkin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2005, 03:37 PM
  5. How do I navigate on a click between linked worksheets in Excel?
    By Animesh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2005, 04:06 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