Macro runs when dropdown is changed

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

Daniel Bonallack

Please could you advise me how to start a macro running
when a cell value changes?

Thanks in advance

Daniel Bonallack
 
How does the cell change value - is it edited by someone (use the
worksheet_change event). Or is it changed through calculation or is it
changed because it has a DDE connection?
 
Hi Tom
The cell value contains the "cell link" from a dropdown
box which the user changes.
So I'll try the worksheet_change event - thanks.

Daniel
 
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

Adding company to an Access table 2
Run Macro If Cell have "x" value 0
Import Access data to text file rather than Excel 3
Recalculating single cell 4
Open Access from Excel 9
SaveAs Dialog box 2
Loop through sheets, deselect charts 4
Test if file exists 2

Back
Top