Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to cell based on input
Hi all
In hoping someone can help I have a cell (c16) the user will input a 1 or a zero into. If its a 1 i want cell (F16) to be selected or if its a 0 cell (C17) to be selected. Cheers in Advance D -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to cell based on input
Put this code in the worksheet module.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$16" Then Select Case Target.Value Case Is = "0": Range("C17").Select Case Is = "1": Range("F16").Select End Select End If End Sub Hope this helps! If so, click "YES" below. -- Cheers, Ryan "dazoloko via OfficeKB.com" wrote: Hi all In hoping someone can help I have a cell (c16) the user will input a 1 or a zero into. If its a 1 i want cell (F16) to be selected or if its a 0 cell (C17) to be selected. Cheers in Advance D -- Message posted via http://www.officekb.com . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to cell based on input
Thanks Ryan
Thats just the job. D Ryan H wrote: Put this code in the worksheet module. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$16" Then Select Case Target.Value Case Is = "0": Range("C17").Select Case Is = "1": Range("F16").Select End Select End If End Sub Hope this helps! If so, click "YES" below. Hi all [quoted text clipped - 8 lines] D -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200912/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill cell colour based on input in another cell | Excel Worksheet Functions | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
email based on cell input | Excel Programming | |||
data validation to restrict input in cell based on value of cell above that cell | Excel Programming |