| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cell change event
I'm having trouble making a subroutine run upon a change to the value in cell
B2. This is the code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "B2" Then Dim Blank_count As Integer etc etc End If End Sub I'm sure I'm missing something obvious, thank you in anticipation! ... Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change info in 1 cell, prompts you for another | Excel Discussion (Misc queries) | |||
| cell value change event | Excel Worksheet Functions | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
| Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Threaded Mode
