Results 1 to 2 of 2
  1. #1
    fkristo
    Guest

    Combo box to navigate to W/sheets

    Does anyone have any ideas on how to create a combo box or menu list to navigate to worksheets within the same workbook???

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo box to navigate to W/sheets

    A combo box on a worksheet or in a userform?

    It's probably not important- the code would be similar in both instances.

    If, for instance, you had a combobox on a worksheet (named cboWorkSheet for instance) populated with the worksheet names, you would have a "cboWorksheet_change" event with a statement like:

    Worksheets(cboWorksheet.Value).Activate

    if the value was not a valid value, you would get a "subscript out of range" error.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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