+ Reply to Thread
Results 1 to 5 of 5

VBA to copy MasterSheet and rename with TextBox value

  1. 03-15-2020, 08:03 PM #1
    bluepomme
    bluepomme is offline
    Registered User
    Join Date
    10-04-2018
    Location
    Cancun, Mexico
    MS-Off Ver
    2013 & 2016 32b
    Posts
    78

    VBA to copy MasterSheet and rename with TextBox value

    Hello

    I have a userform with i like to use to copy a Master Sheet and rename the new Sheet with the Textbox1 Value, that also should display new Worksheet name in Cell A1



    events.xlsm

    thank you for your help
    Last edited by bluepomme; 03-15-2020 at 08:29 PM.
    Reply With QuoteRegister To Reply
  2. 03-15-2020, 11:19 PM #2
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,700

    Re: VBA to copy MasterSheet and rename with TextBox value

    What are we going to do with an empty attached workbook?
    Cell A1 in the Master Sheet or in the newly named sheet
    Reply With QuoteRegister To Reply
  3. 03-16-2020, 07:15 PM #3
    bluepomme
    bluepomme is offline
    Registered User
    Join Date
    10-04-2018
    Location
    Cancun, Mexico
    MS-Off Ver
    2013 & 2016 32b
    Posts
    78

    Re: VBA to copy MasterSheet and rename with TextBox value

    thanks for reply to my post and your interest

    i supposedly added the code that i had so far but it didnt saved ....

    so far I managed it to get it work right now

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-17-2020, 03:09 AM #4
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,700

    Re: VBA to copy MasterSheet and rename with TextBox value

    If you don't want to attach a representative Workbook, maybe a few pointers.

    Security would not let me enter my thoughts so my ideas are in the attached Text File
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-20-2020, 11:58 PM #5
    bluepomme
    bluepomme is offline
    Registered User
    Join Date
    10-04-2018
    Location
    Cancun, Mexico
    MS-Off Ver
    2013 & 2016 32b
    Posts
    78

    Re: VBA to copy MasterSheet and rename with TextBox value

    thank you ,

    i made all changes working fine
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy sheets from multiple worksboos to one Mastersheet
    By moosmahna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2018, 03:02 PM
  2. [SOLVED] Copy Data in Mastersheet from various worksheets in the folder
    By harman83 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-12-2015, 01:40 PM
  3. Cant Rename TextBox
    By oskar44 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2015, 09:30 AM
  4. [SOLVED] Copy a sheet, rename it by value in range then export product to new workbook and rename
    By MagicMan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2015, 07:24 PM
  5. Rename sheet, copy it, rename copy back to original name maintain linked cells in an array
    By thetaplus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2014, 02:26 PM
  6. Copy Folder, Rename from Textbox
    By sternboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2012, 10:52 AM
  7. copy and update problem in mastersheet to other worksheets.
    By larvitar in forum Excel General
    Replies: 1
    Last Post: 06-04-2012, 03:41 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1