+ Reply to Thread
Results 1 to 4 of 4

Userform to rename caption of Multipage as per Checkbox

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    440

    Userform to rename caption of Multipage as per Checkbox

    Hi,

    I have around 6 to 12 Checkbox, depends on the client, but I only create 4 multipage because they cannot add more than 4 different pages.

    So I would like to, if the checkbox is clicked, the multipage caption will be renamed to the first clicked checkbox. If they uncheck it, it will undo the action.
    If they check 2 checkboxes, it will rename the multipage accordingly to the first checkbox, and second checkbox which ever the one that got clicked first.

    Example:
    CheckBox1
    CheckBox2
    CheckBox3
    CheckBox4
    CheckBox5
    CheckBox6

    Page 1
    Page 2
    Page 3
    Page 4

    If CheckBox1 is checked, and CheckBox2 is checked, then
    Page 1 Caption will be CheckBox1, Page2 caption will be CheckBox2.

    If they decided to CheckBox1, CheckBox3, then CheckBox2, then
    Page 1 caption will be CheckBox1, Page 2 caption will be CheckBox3, Page3 caption wil be CheckBox2 (as first one that got checked will be rename first)

    If they decide to check over than the allowed Pages, it will prompt, you cannot add more than 4 checkbox.

    I have attach the userform with the checkbox and pages.

    Hope someone can help on this.

    Thank you.1014468 UserformTest.xlsm

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Userform to rename caption of Multipage as per Checkbox

    I could add as many pages as I like with this code
    Please Login or Register  to view this content.
    (they were run time pages that had to be added every time the UF is invoked, like in the Initialize event

    A Multi-page doesn't have a .Caption, but a .Page does.
    Please Login or Register  to view this content.
    I think this loop will do what you want

    Please Login or Register  to view this content.
    Last edited by mikerickson; 07-07-2014 at 10:51 AM.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,468

    Re: Userform to rename caption of Multipage as per Checkbox

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    440

    Re: Userform to rename caption of Multipage as per Checkbox

    Wow! Thank you very much guys!! and for the attachment!

    Thanks!!!

+ 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. [SOLVED] multipage linking to checkbox [ userform]
    By ohboyherewegoagain in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2014, 01:55 AM
  2. Change Checkbox Caption on Userform with Name in Variable
    By XLVBA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2013, 04:43 PM
  3. Get UserForm checkbox caption and pass to another UserForm on click or mouse down
    By tulsaguy71 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2013, 11:07 AM
  4. Best Placement of Checkbox on Multipage Userform - Excel VBA
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2013, 03:36 PM
  5. Replies: 0
    Last Post: 11-15-2012, 12:29 PM

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