Solved: Which column is the calling button (mostly) in?

[Asterix]

Dear all, I'd like to place buttons in many cells within the title row of a spreadsheet in order to, for example, sort the column that the button is in.

Can I reliably detect which column a button is in (as well as allowing me to resolve instances where the button is split over 2 columns)?

[mdmackillop]

MsgBox ActiveSheet.Shapes(Application.Caller).TopLeftCell.Address

[Asterix]

ta

[Aussiebear]

Hi Asterix, if MD's solution has fixed this issue, can you kindly mark the thread as solved by using the thread tools option?

Thankyou.

[Asterix]

Aah, but in testing have found that this...


Private Sub CommandButton1_Click()
MsgBox ActiveSheet.Shapes(Application.Caller).TopLeftCell.Address
End Sub

...resolves to a type mismatch. Is the problem with the code or the way I've applied the code.

[Bob Phillips]

Perhaps this what you need then



MsgBox Me.CommandButton1.TopLeftCell.Column

[Asterix]

Now that works xld. Thankyou.