+ Reply to Thread
Results 1 to 6 of 6

Dropdown boxes

  1. 04-21-2009, 01:33 PM #1
    Tony McGuire
    Tony McGuire is offline
    Registered User
    Join Date
    01-31-2007
    Location
    Hjoerring, Denmark
    MS-Off Ver
    Excel 2007 and Access (testing 2007)
    Posts
    4

    Dropdown boxes

    Hi
    I have created a dropdown box and it functions well except for one thing that I hope you can help me with.
    The dropdown box is placed on my first opening sheet which I have called 'Start'. When I select an item from the dropdown list it opens the corrct sheet. However, when I return to my start sheet it still shows the previously selected sheet but i want this to show for example a label called maybe 'Select' where I can begin with a new selection. Does this crave a special VBA line or what?
    Tony McGuire
    Reply With QuoteRegister To Reply
  2. 04-21-2009, 02:11 PM #2
    c.vaibhav
    c.vaibhav is offline
    Forum Contributor
    Join Date
    01-13-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2003, 2007
    Posts
    168

    Re: Dropdown boxes

    You can use VBA for this..

    In the VBA - Editor, in Microsoft Excel Objects, go in Sheet1 and use the following code

    Please Login or Register  to view this content.
    Last edited by c.vaibhav; 04-21-2009 at 03:00 PM.
    Reply With QuoteRegister To Reply
  3. 04-21-2009, 02:16 PM #3
    karan
    karan is offline
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Thumbs up Re: Dropdown boxes

    Hi Tony,

    Use this code in the 'Start' sheet VBA module:

    Please Login or Register  to view this content.
    Regards,
    Karan
    Last edited by karan; 04-21-2009 at 03:02 PM.
    Reply With QuoteRegister To Reply
  4. 04-21-2009, 02:59 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Dropdown boxes

    karan, c.vaibhav,

    Please edit your posts to add code tags.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  5. 04-21-2009, 03:04 PM #5
    karan
    karan is offline
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Thumbs up Re: Dropdown boxes

    Hi Moderator,

    I am new to Excel Forum. I did not know about Code Tags. I will make sure I will use them in future.

    --Karan--
    Reply With QuoteRegister To Reply
  6. 04-21-2009, 03:09 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Dropdown boxes

    Thank you, karan.
    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