Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

A particular cell that changes triggers a macro

I need to trigger a macro only if Summary.range("B13") changes. Summary is sheet 5
0
bearblack
Asked:
bearblack
  • 4
  • 3
2 Solutions
 
FloraCommented:
here it is.  put this code into the sheet object

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$b$13" Then
Call YourMacro
End If
End Sub
0
 
Glenn RayExcel VBA DeveloperCommented:
You can do this with a Worksheet_Change event macro that is inserted in Sheet5:
Worksheet_Change event
Regards,
-Glenn
0
 
FloraCommented:
put this code into Summary sheet object
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
FloraCommented:
Glenn I was first   :-)

you were few second late :-)
0
 
Glenn RayExcel VBA DeveloperCommented:
Yep; that's what I get for creating a pretty graphic. :-P

-Glenn
0
 
bearblackAuthor Commented:
Tried it and ANY cell that changes on the Summary sheet triggers the private sub.
0
 
Glenn RayExcel VBA DeveloperCommented:
You'll have to show us your code; if you used either Flora20's or my example, it would only happen if cell B13 of Sheet5 (Summary ?) was changed.

-Glenn
0
 
FloraCommented:
can you check the attached file.
F--F--Book1.xlsm
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now