Run a macro from selecting a cell

  • Thread starter Thread starter Tony Pleasant
  • Start date Start date
T

Tony Pleasant

In Excel 2000, I am building a dashboard that will run
several macros, view charts, view data, ect. My question
is when a particular cell is selected (B4) I would like
for it to run a macro "BLSPG".

TFTH,
Tony
 
Hi Tony
Right click on your worksheet tab, View code and paste:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$4" Then
BLSPG
End If
End Sub

HTH
Cordially
Pascal
 
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

Pop-up when running a macro 5
Macro Help 2
Using VBA To Enter A Sumproduct Formula Into A Cell 0
Pasting cell contents into a macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Decimal dot to Decimal Comma 3
Create a new Excel file with selected cells 2
On Open Macro 2

Back
Top