+ Reply to Thread
Results 1 to 4 of 4

Changing order of Multipage tabs via vba

  1. #1
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Bournemouth
    MS-Off Ver
    Excel 2003
    Posts
    158

    Changing order of Multipage tabs via vba

    Hi

    I'm trying to change the order of a multipage based on a selection of a combobox. I cant find a way of doing it.

    Does anyone have any suggestions?

    Thanks

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Changing order of Multipage tabs via vba

    I'm not sure why you'd want to, but you can just set the Index property of the page to whatever you want.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Bournemouth
    MS-Off Ver
    Excel 2003
    Posts
    158

    Re: Changing order of Multipage tabs via vba

    Thanks

    do you have an example? It does not like any of my attempts

  4. #4
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Bournemouth
    MS-Off Ver
    Excel 2003
    Posts
    158

    Re: Changing order of Multipage tabs via vba

    Don't worry. I have figured it out.

    Thanks again

+ 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. Replies: 4
    Last Post: 03-17-2015, 04:36 AM
  2. [SOLVED] Multipage tabs: is it possible to program an on-click code?
    By Lkivagten in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2012, 05:58 PM
  3. controlling multipage tabs
    By alann2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2006, 03:17 AM
  4. Add tabs to multipage in userforms
    By shnim1 in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 03:45 AM
  5. Multipage - Tab Order
    By Rastus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2006, 01:20 AM

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