| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Event
Add to worksheet module:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$1" Then 'add code here or call macro 'change $B$1 to suit End if End Sub Hth, Merjet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
| Change event and calculate event | Excel Programming | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
| change event/after update event?? | Excel Programming | |||
Threaded Mode
