Starting a macro by editing a cell

  • Thread starter Thread starter Yiannis
  • Start date Start date
Y

Yiannis

I would like a macro to be initiated whenever someone edits a particula
cell, does anyone now how this can be done?

Many Thanks,

Yianni
 
Yiannis

You would need on change macro in the worksheet module




Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then

my code gets actioned here
if target.value = "" then
exit sub
end if
End If
End Su
 
You must log in or register to reply here.

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

Excel Run macro upon cell edit 0
Auto time recording in another cell for data entered in one 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Hyperlinks become inacative, why? 1
Macros - Tickmarks 0
Converting DD/MM/YYYY format into text MMYYYY 3
Auditing - Tickmarks 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top