asked on

Detect Column index pressed in Excel

Hello EE,

How can I know via code (macro) which column index was Clicked (cell or header) ?

What is the code behind for that ?

if I press Cell (3,3) I would like to know that it was Column 3 or ("C")

kgerb

put the following in the worksheet code pane for the desired worksheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "A cell in column " & Target.Column & " was clicked"
End Sub

Open in new window

Kyle

Philippe Renaud

ASKER

Ok, do you know maybe was is the difference in VB ?
actually its a Excel control I have and I have the same possible event except that it goes as follow:

Private Sub AxSpreadsheet2_SelectionChange(sender As Object, e As System.EventArgs) Handles AxSpreadsheet2.SelectionChange

End Sub

I dont have Target as Range inside... the parameter is e as EvenArgs...

maybe it's out of your scope ?

kgerb

Yeah, I'm not up on .Net. Just VBA. I'll go get help.

EDIT:
Ok, the cavalry will be here soon.

Kyle

Philippe Renaud

ASKER

You gonna request attention ?

kgerb

I already did

Philippe Renaud

ASKER

thanks, If I may... also, I was asking this quesiton because I was trying to get the column click when a user delete the entire column.

I have 2 Spreadsheet and when the user delete a column I wanted to programmatically delete the same column on the other spreadsheet...but looks like there is no event for the column deleted...

so I thought If I can know the column index before then I compare the excel sheets.. I could my self delete the column

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Philippe Renaud

ASKER

Thanks, also I have a bigger problem related to Excel Control on this question :

https://www.experts-exchange.com/questions/27635758/AxSpreadSheet-control-ClassFactory-Error.html

Any idea excel experts? Im getting crazy not finding a solution.