+ Reply to Thread
Results 1 to 3 of 3

How to Rename Multipage In userforms?

Hybrid View

  1. #1
    Registered User
    Join Date
    09-19-2020
    Location
    Mousorie
    MS-Off Ver
    2016
    Posts
    2

    Post How to Rename Multipage In userforms?

    Hello Folks VBA Experts out here,

    Im new here ,I hope everything is going fine.

    I have some doubts

    I tried simple method of caption

       Private Sub CommandButton Click()
       With TextBox20
       UserForm1.MultiPage1.Pages(0).Caption = .Text
       End With
       End Sub
    After I re-named it , & clicked Save the userform1 its showing the same Old Name after clickling the userform1, is there any Solution that I can Re-Name my userform-multipages? So that it saves the new name of Multipages,and old one gets deleted, please let me know in the comments Section Below , I have attached a Jpg file for the reference , Please Share your idea friends.#Urgent Thanks & Regards
    Attached Files Attached Files
    Last edited by davesexcel; 10-12-2020 at 06:26 AM.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: How to Rename Multipage In userforms?

    you need somewhere to store your dynamic changes.
    why not just use your project sheet name tabs to populate the multipage tabs on initialisation - solves the problem without resorting to saving captions.
    leave the multiform page captions blank in the pages properties.
    bear in mind that page references are zero based

    Private Sub UserForm_Initialize()
    Dim x As Integer
    For x = 2 To 6
    Me.MultiPage1.Pages(x - 2).Caption = Sheets(x).Name
    Next x
    End Sub
    Last edited by torachan; 10-12-2020 at 07:40 AM.

  3. #3
    Registered User
    Join Date
    09-19-2020
    Location
    Mousorie
    MS-Off Ver
    2016
    Posts
    2

    Re: How to Rename Multipage In userforms?

    Hi torachan,
    Thank you for the reply , Unfortunately , I cannot change the Caption properties of the Multipage , because it is dependent on the Sheet ranges. There are multiple Users, therfore They Can only identify their projects based on Multiform caption name ...
    -Regards

+ 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. COMBINE SEVERAL USERFORMS IN A MULTIPAGE ONE - excel 2010
    By mariec_06 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2016, 08:58 AM
  2. Multipage problem with userforms
    By zhenry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2014, 11:00 AM
  3. [SOLVED] Printing multi layer multipage userforms
    By MeerkatMatt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2014, 11:22 AM
  4. [SOLVED] Userform to rename caption of Multipage as per Checkbox
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2014, 11:07 AM
  5. [SOLVED] ActiveControl - Return non-Multipage control when Form contains Multipage?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-04-2014, 08:37 PM
  6. [SOLVED] multipage userforms
    By mickisme in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-27-2012, 04:01 AM
  7. Add tabs to multipage in userforms
    By shnim1 in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 03:45 AM

Tags for this Thread

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