which commandbutton was pressed

[RAYLWARD102]

How can I find out what commandbutton was just pressed in my userform.

example: msgbox commandbutton.caption

I know the above wont work but its what I want; just don't know how to get it. I do not want want to refer to the number of the button that was just pressed...example: msgbox commandbutton1.caption

 

[RAYLWARD102]

what I'm really wanting to do is use the caption in the button that was pressed to determine which column to read from for the next procedure.
There are many buttons and I'd rather paste a generic code into each of them to set the variable from the caption of what ever button was pressed. I dont want to reference the actual button number. (just the button that was clicked!)