| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run macro based on range value
How can I create a macro that whenever I type "y" or "Y" in "O" column, it
run a macro. thx. -- Message posted via http://www.officekb.com |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Run macro based on range value
This code is worksheet event code so it must be posted into the sheet. Right
click the approporate tab and select View Code. Paste the following... Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 15 And UCase(Target.Value) = "Y" Then MsgBox "Run your macro" End If End Sub -- HTH... Jim Thomlinson "saman110 via OfficeKB.com" wrote: How can I create a macro that whenever I type "y" or "Y" in "O" column, it run a macro. thx. -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| Macro to insert a formula based on a range | Excel Discussion (Misc queries) | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Linear Mode
