• Counter button in Excel (Excel 2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Counter button in Excel (Excel 2003)

    Author
    Topic
    WScreser
    AskWoody Lounger
    June 8, 2006 at 9:20 pm #432656

    How can I create a macro with button to easily count activities? I have multiple staff persons providing customer service in a variety of categories. I would like to create an easy way for them to click a button under the category of service provided to customers. Can this be done in Excel with a macro and command button for each category? Each staff person has a worksheet with the buttons that adds to the tally on a master sheet. Open to suggestions.Thanks…..

    Reply | Quote
    Viewing 2 reply threads
    Author
    Replies
    • WSsdckapr
      AskWoody Lounger
      June 8, 2006 at 9:31 pm #1015471

      We would need a lot more info to provide a macro. COuld you provide more details and perhaps a sample sheet with proprietary info deleted.

      If I understand your setup, a non-macro solution would be to use autofilter and the subtotal function. Subtotal will not count the itmes removed in the filter, so by clicking on the picklist for the filter (and multiple ones can be selected) the count, average, min, max, etc of the filtered data can be displayed.

      Steve

      Reply | Quote
    • WSHansV
      AskWoody Lounger
      June 8, 2006 at 9:35 pm #1015472

      If you create the command buttons from the Forms toolbar, you can write macros for them in a standard module and assign them to the buttons – when you create a new button, you are prompted to assign a macro, and later you can right-click a button and select “Assign macro” from the popup menu). Code could look like this (substitute the appropriate cell):

      Sub IncreaseActivityA()
      Range(“B37”) = Range(“B37”) + 1
      End Sub

      If you create a command button from the Control Toolbox, you are automatically switched to design mode. Double click the button to create an event procedure for the Click event in the module associated with the worksheet. Code could look like this:

      Private Sub CommandButton1_Click()
      Range(“B37”) = Range(“B37”) + 1
      End Sub

      Cells referring to the affected cell (B37 in my example) will be updated automatically.

      Reply | Quote
      • WScreser
        AskWoody Lounger
        June 8, 2006 at 9:40 pm #1015473

        Giving this a try right now and will let you know. Thanks….

        Reply | Quote
      • WScreser
        AskWoody Lounger
        June 9, 2006 at 1:45 pm #1015544

        I can get the button to add count within the same worksheet but can’t figure out how to get it to go to another worksheet in the same workbook or another workbook. I can’t figure out the correct syntax. Can you help me with this also? Thanks…

        Reply | Quote
    • WSHansV
      AskWoody Lounger
      June 9, 2006 at 1:54 pm #1015546

      Another worksheet in the same workbook:

      Worksheets(“Sheet3”).Range(“B37”) = Worksheets(“Sheet3”).Range(“B37”) + 1

      A worksheet in another workbook (which must be open):

      Workbooks(“Tally.xls”).Worksheets(“Sheet3”).Range(“B37”) = Workbooks(“Tally.xls”).Worksheets(“Sheet3”).Range(“B37”) + 1

      Another option would be to increase a cell in the same worksheet, as in the code I originally posted, and to place a link to that cell in another worksheet (in the same or another workbook).

      Reply | Quote
    Viewing 2 reply threads
    Reply To: Counter button in Excel (Excel 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.