Results 1 to 14 of 14

How I decode VBA with Change sheet name from cell A2

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2007
    Posts
    28

    Smile How I decode VBA with Change sheet name from cell A2

    Dear
    Kindly revise my code not work after change sheet name from cell name
    Step
    1.If change name Worksheet("INPUT") in Colum A2 suach as "U21-U21"
    2.Change name at Work sheet("1") = same name in worksheet("INPUT") in Colum A2 suach as "U21-U21"
    Remake
    Name in Worksheet("INPUT") at colum "A2" can change name any time depends on what I wrote

    Thank you


    Private Sub CommandButton1_Click()
    Dim my As Range ' Variable declaration at cell traget
    With Worksheets("INPUT")
        Set my = .Parent.Worksheets(.Range("a2").Value).Worksheets(1).Name = "A2"
        
    End Sub
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 01-13-2020 at 11:02 AM. Reason: Replace HTML with code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Is there a formula to decode URL's?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 12-14-2021, 01:15 AM
  2. Decode this formula
    By tcolyer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2018, 03:39 PM
  3. Decode the Cells
    By navneetvyas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2017, 03:35 AM
  4. [SOLVED] msgpack decode in VBA
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-29-2015, 10:58 AM
  5. Scramble Text and Decode
    By unclejemima in forum Excel General
    Replies: 6
    Last Post: 08-16-2015, 09:14 AM
  6. Decode text in a cell encoded in basecode64
    By renderman7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2012, 05:06 AM
  7. [SOLVED] Change workbook sheet reference using cell A1 to change a vairable
    By Reed in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2005, 04:06 PM

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