Macro to move cursor to letter in column

[Canoer]

I am using Excel 2013. In this worksheet there is a column with single letters A thru Z. There are buttons labeled A thru Z. For example there is a button on the sheet labeled "C". I want a macro so that when I click "Button C", it will move the cursor down the column until it arrives at the letter "C" in the column, and stop there. Is this possible?

Any help would be appreciated. Thanks

 

[Micron]

I think it matters if the buttons are ActiveX controls or not. If so, perhaps something like this?

Private Sub CommandButton1_Click()
Dim rng As Range

Set rng = Cells.Find(What:=CommandButton1.Caption, LookIn:=xlValues, Lookat:=xlWhole)
If Not rng Is Nothing Then
    rng.Select
End If
End Sub

If you have 26 of these buttons I would suggest using another way. One would be to place that in a standard module so that any button can call it. You'd still need an event for all 26 buttons though. Another might be to write one class that captures all button clicks but I have nothing for that.

If your buttons are not ActiveX controls then that code won't work and I have no idea if a class will work with form controls but I think not.
To refer to the text shown in a form control and use that in the What part is more like
What:=Sheets("SheetNameHere").Shapes("Button Name Here").TextFrame.Characters.Text

I find that for some very odd reason the button name is not what Excel uses in the beginning line of the sub. F'rinstance I would see
Sub MASTER_Button1_Click
but the given button name is "Button 1". If you try to use what's shown you'll end up very frustrated.