Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Something has to trigger Excel to evaluate G10=G160 and
then select J160 if it is TRUE. What will trigger it? One possibility is a Worksheet_Change event so that if cells G10 or G160 are changed by the user, the macro will fire. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("G10,G160")) _ Is Nothing Then If Me.[G10].Value = [G160].Value Then Me.[J160].Select End If End If End Sub --- To use, right-click on the worksheet tab and choose "View Code". Paste in the code above and press ALT+Q to close VBE. HTH Jason Atlanta, GA -----Original Message----- jI WANT TO BE ABLE TO ISE SOMETHING LIKE THIS @IF G10 =G160, GOTO J160 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
Can 2 different hyperlinks be in the same Excel cell? | Excel Worksheet Functions |