+ Reply to Thread
Results 1 to 3 of 3

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
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    97

    Re: commandBtn Caption to sheet name

    Hello,

    show your code and we can help you to amend it.
    Greetings

    Tor


  3. #3
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: commandBtn Caption to sheet name

    @ideatronz;

    See this:

    Please Login or Register  to view this content.
    Last edited by Haluk; 07-31-2020 at 05:28 AM.

+ 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. 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
  2. [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
  3. 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
  4. [SOLVED] Label caption
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-25-2013, 09:31 AM
  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