Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Userforms

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Ithaca
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Daft question this, but:

    I have some userforms with multiple pages on them and I want to put in buttons, so that if you push the button on page 1, it will flick you to page 2.

    But I can't remeber / figure out the code to do this........

    TIA, Rusty

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Could you not just use the multipage control?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Alternatively have a look here: -

    http://www.mrexcel.com/board/viewtop...c=3719&forum=2

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Ithaca
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    As in clicking on the tabs at the top?

    Yeah, just curious how to do it with buttons, and also the code to actually select the different sheets.

    As in when you load up the user form, it shows page one.

    Then I select page 2 then unload.

    When I select the userform again, it starts on page 2.

    So mainly curiousity I guess...

    Thanks for the reply

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Audiojoe has a thing on his userform tutorial about moving it with buttons, why dont you get it from him?

    I tried posting a mail he sent me about it but the format went crazy

    Janie x

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Location
    Ithaca
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mudface,

    Thanks very much for the link, much appreciated. I did a search, but couldn't find anything.

    I'll look into that.
    ----------

    Buntykins,

    AudioJoe sent me a copy of that, you want I try sending to you as well?

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No I have it thanks. There is an example of multipages being controlled by buttons in there though, did you not see it? I was going to use it for a userform I'm doing

    Janie

    xx

  8. #8
    Board Regular
    Join Date
    Apr 2002
    Location
    Ithaca
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Buntykins,

    To be honest, I didn't see it. I guess I'd better take another look.......

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Pffftt, so-called Audiojoe.

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    So-called?? It's right there in bold...Mudface...


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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