Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Good afternoon Tommy_gtr Welcome to the world of event procedures! You haven't given much background information about your project, s I've assumed that your strikethrough macro is named macro1, and tha you want to type OK in cell A1. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target A Range) If Range("A1").Value = "OK" Then Call macro1 End Sub The code above will need copying into the ThisWorkbook pane within you VBE and will call macro1 whenever "OK" is inserted into A1. For mor info on event procedures have a look he http://www.cpearson.com/excel/events.htm HTH Dominic -- dominic ----------------------------------------------------------------------- dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893 View this thread: http://www.excelforum.com/showthread.php?threadid=39418 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing font style and color using VBA | Excel Discussion (Misc queries) | |||
Change the Font Style in VBA | Excel Discussion (Misc queries) | |||
font style of worksheet functions | Excel Worksheet Functions | |||
Toggle Font Style Macro | Excel Programming | |||
Function that returns font style | Excel Programming |