Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a this code. the problem is when the "Card Entered" part is also a value change...so it just keeps repeating. is there a way to make it so if value = "Card Entered" the code does not run Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("fa7").Address Then Range("fc7").Value = Range("fa7").Value Range("fa7") = "Card Entered" End If End Sub ThaNKS in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |