+ Reply to Thread
Results 1 to 4 of 4

How to give specific Name to command button in shet1?

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    713

    How to give specific Name to command button in shet1?

    Hi,

    Everytime below macro runs it creates new button name (Red color script), which makes it difficult for my macro to format it as per remaining code.

    Please Login or Register  to view this content.
    Any advice, as to how can I keep button name same whenevr I run this macro.?

    Thanks
    Last edited by shiva_reshs; 09-18-2013 at 11:21 AM.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: How to give specific Name to command button in shet1?

    Maybe?
    Please Login or Register  to view this content.
    Its already selected when you add, why select it again?
    Last edited by Solus Rankin; 09-18-2013 at 11:22 AM. Reason: edited code
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    713

    Re: How to give specific Name to command button in shet1?

    oh!, right. Not sure why I had
    Please Login or Register  to view this content.
    while recording macro.

    Thanks!!..
    Regads

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: How to give specific Name to command button in shet1?

    The recorder often does things we can't completely understand.

    If this solves your problem please mark the thread as [SOLVED].

+ 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. Replies: 1
    Last Post: 08-12-2013, 08:38 AM
  2. Replies: 2
    Last Post: 08-12-2013, 06:19 AM
  3. Static left hand side column and static header row.. how?
    By glic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2007, 01:45 AM
  4. [SOLVED] Static time - again
    By Maverick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2006, 02:20 PM
  5. "Static" Behavior without Static Defn
    By Steve Drenker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2006, 09:35 PM

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