Results 1 to 5 of 5

Thread: How to create type of Counter button on Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    21

    How to create type of Counter button on Microsoft Excel

    How would I go about coding a command button to advance a number in another cell by 1 each time the button is clicked, like a counter ?

  2. #2
    Join Date
    Jun 2011
    Posts
    798

    Re: How to create type of Counter button on Microsoft Excel

    Click on View > Toolbars > Forms. In the box that appears, click Button (second down on the right) then click in the worksheet. In the box that appears click New Underneath Sub Botton1_Click enter:-Range("A1") = Range("A1") + 1. Press Alt and F11 to close the window. Change A1 to suit and you can rename the button by right clicking it.

  3. #3
    Join Date
    May 2011
    Posts
    448

    Re: How to create type of Counter button on Microsoft Excel

    After creating you command button assign this code. You might also consider doing some error checking because it the cell contains text adding 1 will
    give an error.
    Code:
    Sub Button1_Click()
    Range("A1").Value = Range("A1").Value + 1
    End Sub

  4. #4
    Join Date
    May 2011
    Posts
    410

    Re: How to create type of Counter button on Microsoft Excel

    Hide the Control Toolbox, by you doing up at your icons, right-click. It should now open a new menu bar. These select the button and drag it to the place you want to put your button. First, right click on Properties. There, you can make under the caption label. Now double-click on the button NEN: You're now in the VBA editor and there you should then just set your area, you want to delete. for example: Both A1: C3

  5. #5
    Join Date
    Aug 2011
    Posts
    695

    Re: How to create type of Counter button on Microsoft Excel

    Run the macro, you can perform using the control button. The control button can be placed on the worksheet on, the toolbar or in a custom form. Before you create a button on the Excel worksheet to create the macro. The easiest way to create a macro. To place a button on a worksheet, you must Call Panel Visual Basic, then run View from Toolbars on Visual Basic. Call Control Panel by clicking the Controls Panel, Visual Basic. Create a button for the desired size in the right place at the worksheet by clicking on the button Panel controls. After you click on the Button control and move the mouse pointer on the worksheet cursor appears in the form of a dagger, with which and to determine the parameters of buttons.

Similar Threads

  1. How to rename from button with macro in Microsoft Excel
    By Kanshin in forum MS Office Support
    Replies: 16
    Last Post: 24-02-2012, 01:59 PM
  2. Microsoft Excel Save button is not working
    By Haimi-32 in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 12:57 PM
  3. How to configure navigation button on Microsoft Excel 2007
    By Limitless in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 07:41 PM
  4. Replies: 2
    Last Post: 21-01-2012, 01:24 PM
  5. How to type X bar in Microsoft Excel
    By $horizon$ in forum MS Office Support
    Replies: 4
    Last Post: 18-01-2012, 06:53 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
  •  
Page generated in 1,642,824,282.51519 seconds with 17 queries