Reply

M

Mike H

Hi,

You can capture these values using the worksheet change event. Right click
the sheet tab, view code and paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Value & Chr(13) & Target.Address & Chr(13) & Target.Column &
Chr(13) & Target.Row
End Sub

change a cell and a message pops up with the value, address, row and column

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Pass condition formatting across worksheets via vba. 0
VBA Error Message HELP!!!!! 0
Help - hiding multiple sets of rows based on two different cells 2
Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
DV0017 - Debra's Validation Code 1
Change_Event not responding to change made by formula. 11
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2

Top