Home |
Search |
Today's Posts |
#1
|
|||
|
|||
[B]Conditional Macro?[/B]
Hey. Is it possible to activate a Macro when a cell contains a certain value? or anything similar -- Heydilbert ------------------------------------------------------------------------ Heydilbert's Profile: http://www.excelforum.com/member.php...o&userid=28748 View this thread: http://www.excelforum.com/showthread...hreadid=484412 |
#2
|
|||
|
|||
[B]Conditional Macro?[/B]
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "H1" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target If .Value = 99 Then 'do your stuff End If End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "Heydilbert" wrote in message ... Hey. Is it possible to activate a Macro when a cell contains a certain value? or anything similar -- Heydilbert ------------------------------------------------------------------------ Heydilbert's Profile: http://www.excelforum.com/member.php...o&userid=28748 View this thread: http://www.excelforum.com/showthread...hreadid=484412 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can T Get Macro To Run! | New Users to Excel | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
save original data after macro is run again | New Users to Excel | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |