Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to run a macro called hardware when the user clicks in cell C14.
I am new to VB in Excel, but use VB in Access. When I run the following code in debug mode, I can see that it is skipping the instructions after "then" in the if statement even when the target address is $C$14. What am I missing? Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$c$14" Then MsgBox "Hardware" End If End Sub Thanks Sammie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Button Visibility / Selectionchange Problem | Excel Programming | |||
Worksheet SelectionChange Event | Excel Discussion (Misc queries) | |||
Worksheet SelectionChange event | Excel Programming | |||
selectionchange problem | Excel Programming | |||
SelectionChange problem | Excel Programming |