+ Reply to Thread
Results 1 to 3 of 3

Clickable counter button macro for array

  1. #1
    Registered User
    Join Date
    11-20-2011
    Location
    Miami, FL
    MS-Off Ver
    Excel 2007
    Posts
    1

    Clickable counter button macro for array

    Please see example sheet "SYLAR VBA TEST.xlsx" uploaded to forum for background information.

    Looking for macros for clickable buttons placed in columns B and C, next to OPERATOR names (Column A), which buttons affect value of cell in an array where the cell column corresponds to column with current date as column header, and the row corresponds to the row where the clicked button resides.

    Thank you for your help.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Clickable counter button macro for array

    I only have Excel 2003. If you save the file as xls, I'll take a look at it.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Clickable counter button macro for array

    It may be better to use double click instead of buttons. Try double-clicking in the cells B2:C8
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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