Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: If sheet1 cell A1 = "1" then Application.Run "MyMacro&quot

Status
Not open for further replies.
coolcarls

coolcarls

Technical User
Jan 19, 2002
182
US
Can I run a macro when a cells value meets a certain criteria?
Thanks again to all
 
Sort by date Sort by votes
Yes,...put your code in a function instead of a sub

the following runs a function called run_me that has a msgbox("msg here")if a1 >10

=IF(A1>10,run_me(),"")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ladyck3
  • Locked
  • Question
Excel 365: I'm new to Tables - Configuring Font & "Get Data from Table/Range" 2
Replies
4
Views
431
ladyck3
ladyck3
ladyck3
  • Locked
  • Question
Excel 365: [SOLVED ]Data Dump Date: "Jul 12 20:27:14 CDT 2022" convert to 07/12/2022 2
Replies
8
Views
412
ladyck3
ladyck3
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
349
combo
combo
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
576
mintjulep
M
Andrzejek
  • Locked
  • Question
Formula with & and a single quote 2
Replies
4
Views
984
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top