+ Reply to Thread
Results 1 to 3 of 3

How to Rename Multipage In userforms?

  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

    Please Login or Register  to view this content.
    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,302

    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

    Please Login or Register  to view this content.
    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