Return the Name/Caption and Color of a Command Button

**mitchbvi@mac.co** · 11-03-2007, 05:19 PM

I have developed code to build a dynamic calendar. One of the last things I need to do is return the name and color assigned to a command button on my worksheet. When I create the buttons the intention is the data on the button goes into the appropriate cell in the calendar and the color matches that of the text. However I cannot figure out how to return that information when I click on the button any suggestions please. I could type in the data again (as Ic an see it onthe button) but that is not efficent.

Peter:

**shg** · 11-03-2007, 05:36 PM

Like this?

Private Sub CommandButton1_Click()
    With CommandButton1
        MsgBox "Caption: " & .Caption & vbLf _
        & "Name: " & .Name & vbLf _
        & "Color: " & .BackColor
    End With
End Sub

**mitchbvi@mac.co** · 11-03-2007, 05:52 PM

I build the buttons dynamically and as I build them I assign a routine to them. That routine does not know what the name/caption of the command button is. So your suggestion will not work but thank you for the suggestion. Is there a way of writing a sub routine using code?

As I click the button I need to return the properties of that button I hope that does not sound stupid. If you would like me to post the code that builds the button please let me know.

Thanks

Peter

**shg** · 11-03-2007, 06:03 PM

Why go to the trouble of creating a command button in code, rather than creating a calender input in a cell, formatting as you wish, and pushing a button (or just double-clicking the cell) to move the text (and its formatting) to the calendar?

**mitchbvi@mac.co** · 11-03-2007, 10:28 PM

Because what I am doing is prpearing a calendar that records locations. So When I am asked for the data I also specify the duration and it fills in the data andf colors for "X" days and this changes all the time.

Regards

Peter

**shg** · 11-03-2007, 11:22 PM

I guess my question is, what additional information can you convey with whatever formatting and attribution you can apply to a command button that you might not equally convey via alternative and simpler means?