Results 1 to 4 of 4

Determining which Active x button was pressed?? I have two Active X buttons that operate

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-28-2013
    Location
    Green Bay, WI
    MS-Off Ver
    Excel 2007
    Posts
    125

    Determining which Active x button was pressed?? I have two Active X buttons that operate

    I have two Active X buttons that operate almost identical operations. The only difference is one of them operates a set of if statements and the other one doesn't. They both send a copy to the History Sheet, but the copy they send looks identical. There is no way of telling which button was pressed. I have to go back and look for mistakes made by other people using this workbook and I have no way of knowing which Active X button they really pressed. It is assumed they always use the Inventory(red) button, but I have no way of knowing for certain.

    I was hoping to be able to send the name of the Active X button pressed to column (I) with the amounts already being transferred to the History Sheet. I'm not really sure how to go about this and I am looking for any help or suggestions.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy sent to "History Sheet" everytime the Active X button is pressed.
    By Spreadlover in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-26-2013, 08:40 PM
  2. [SOLVED] Selecting or determining the active row.
    By Spreadlover in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2013, 08:31 PM
  3. [SOLVED] how to lock a range of buttons when a main button is pressed in vba
    By jakeembx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:40 PM
  4. [SOLVED] Determining last active cell in a protected worksheet
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2006, 12:45 PM
  5. How to Operate the active Excel Window with VB6
    By NTorch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 10:55 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