Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good morning!
I have the following code in my program. When I change the contents of cell M16, I expect that this code will be activated. However, the program doesn't even look at it. Am I doing something wrong?? Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Worksheets("EDGING").Range("M16") = "BEVEL" Then Worksheets("EDGING").Range("A102") = "BevelRadius" ElseIf Worksheets("EDGING").Range("M16") = "PENCIL POLISH" Or _ Worksheets("EDGING").Range("M16") = "HIGH FLAT POLISH" Then Worksheets("EDGING").Range("A102") = "FlatPencilRadius" Else: Worksheets("EDGING").Range("A102") = "None" End If End Sub Thanks, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change the code in another worksheet | Excel Programming | |||
change the name of a worksheet/update VBA code | Excel Discussion (Misc queries) | |||
Change Code from a Worksheet | Excel Programming | |||
Code Conflicts With Worksheet Change Code | Excel Programming | |||
Worksheet change code | Excel Programming |