Closed Thread
Results 1 to 2 of 2

commandBtn Caption to sheet name

  1. #1
    Registered User
    Join Date
    07-30-2020
    Location
    kuwait
    MS-Off Ver
    10
    Posts
    2

    Exclamation commandBtn Caption to sheet name

    i have a commandbutton on a userform. when clicked this command button creates a worksheet.This is done. but the problem is that i want the worksheet's name to be the same as the commandbutton's caption.Any help please

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    17,892

    Re: commandBtn Caption to sheet name

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. commandBtn Caption to sheet name
    By ideatronz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2020, 05:24 AM
  2. Getting Label Caption Value And Insert them to specific sheet with Submit Button
    By hensin3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2018, 04:48 AM
  3. [SOLVED] Userform checkbox caption to hide work sheet
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2017, 08:08 AM
  4. ActiveX Label Caption equal to activecell on different sheet
    By mitchell163rd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2014, 11:56 PM
  5. [SOLVED] Is it possible to do a comm.button with scrolling caption /changing caption?
    By Lkivagten in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2012, 08:10 AM
  6. caption + 1
    By RetepNamenots in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2006, 08:19 AM
  7. How to reference win.caption, when caption changes
    By Paul987 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2006, 12:09 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