Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code - different Worksheet
Hi
you need a event procedure for this. Enter the following in your worksheet module of the first sheet (assumption cell A1 is the cell you enter your data) Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub On Error GoTo CleanUp: With Target if .value <"" then Application.EnableEvents = false worksheets(.value).activate end if End With CleanUp: Application.EnableEvents = True End Sub -- Regards Frank Kabel Frankfurt, Germany tennec wrote: I would love some assistance in writing some code that would look at the data entered(three choices) in a cell that would then go to one of three different worksheets. For example, if "A" is entered in a cell, then this would take you to worksheet "A". Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with worksheet code | Excel Worksheet Functions | |||
worksheet code | Excel Discussion (Misc queries) | |||
Worksheet Code | Excel Discussion (Misc queries) | |||
Need Worksheet Code | Excel Worksheet Functions | |||
worksheet code | Excel Discussion (Misc queries) |