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.

Hi
Modify the code for each Active X button as follows:

Please Login or Register  to view this content.

Hope this helps.
Good luck.
Tony

Please Login or Register  to view this content.

This is the code I wound up using. It puts the name of the Active X button at the end of the row for a split second and then transfers it to the History sheet with the other data before it clears the entries.

And for anyone who doesn't like seeing the annoying flash of something popping up quick and then disappearing like me, turn off the screen updating.

Please Login or Register  to view this content.