+ Reply to Thread
Results 1 to 2 of 2

Show value CommandButton in a Label

  1. #1
    Registered User
    Join Date
    07-26-2014
    Location
    Brussels
    MS-Off Ver
    MS Office 2010
    Posts
    22

    Show value CommandButton in a Label

    Hello,

    I have an userform with 4 CommandButtons I would like to modify. Clicking on Commandbutton 1, 2 or 3 increments the value with 1 and shows the result in the command button.I would like to show the values in the corresponding labels or eventually in Textboxes rather than in the CommandButton because the Commandbuttons will contain pictures.CmdButton.xlsm Even better would be if those Commandbuttons could be linked to a spinbutton (+1 or -1)
    How can I do this? I attached the file CmbButton.xslm

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,178

    Re: Show value CommandButton in a Label

    The label lblBtn1.caption = lblBtn1.caption + 1

+ 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. [SOLVED] Show ListBox based on CommandButton
    By WimpieOosthuizen in forum Excel General
    Replies: 5
    Last Post: 06-17-2014, 08:46 AM
  2. Disable commandbutton if Label and Multipage index is..
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2014, 04:52 PM
  3. Commandbutton in userform to execute code based on a previous commandbutton choice?
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2012, 03:28 PM
  4. Have CommandButton show for specific user
    By penny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2010, 01:08 PM
  5. How to make a commandbutton show in all sheets?
    By Bluewhistler in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-14-2010, 11:14 AM

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