+ Reply to Thread
Results 1 to 7 of 7

button with multi choice

  1. 12-10-2008, 09:51 AM #1
    megabytecompute is offline
    Registered User
    Join Date
    01-05-2008
    Location
    uk north east coast
    Posts
    34

    button with multi choice

    is ther away of usin 1 button to open any 1 to 46 worksheets
    i know i can make a button to open a sheet with the command
    sheet2.activate
    but this means i would have to have 46 buttons on the fron page and thats to many
    Last edited by megabytecompute; 12-12-2008 at 11:44 AM. Reason: issue solved
    Reply With QuoteRegister To Reply
  2. 12-10-2008, 09:59 AM #2
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523
    Just right click on the sheet navigation arrows at the bottom left of your screen
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 12-10-2008, 10:02 AM #3
    rwgrietveld is offline
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671
    Good one. Didn't know that
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com     (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com     (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo
    Reply With QuoteRegister To Reply
  4. 12-12-2008, 05:41 AM #4
    megabytecompute is offline
    Registered User
    Join Date
    01-05-2008
    Location
    uk north east coast
    Posts
    34

    open a given sheet

    that helps but if the sheet is hidden that option does not help
    wat i want is to make a button that i can pick a name from list and this will activate the sheet
    Reply With QuoteRegister To Reply
  5. 12-12-2008, 09:32 AM #5
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523

    List Worksheet in a UserForm

    Check out this example,
    The original code I found here
    So that you can activate hidden sheets I slightly modified the Listbox Click code to:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 12-12-2008, 11:43 AM #6
    megabytecompute is offline
    Registered User
    Join Date
    01-05-2008
    Location
    uk north east coast
    Posts
    34

    magic button

    thanks thats magic
    Reply With QuoteRegister To Reply
  7. 12-12-2008, 11:52 AM #7
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    This should work as well

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1