#1
|
|||
|
|||
moving to to different sheet
hello, i'm hoping someone can assist me. for starters i am very new and inexperience in VBA.
scenario is: i have four sheets, for simplicity lets call sheet 1 "names", sheet 2 "bob", sheet 3 "tom" and sheet 4 "sue". on sheet "names" i have a drop list with the names and depending on which name is chosen the pointer will be moved to A1 of the sheet which matches the name chosen. thanks |
#2
|
|||
|
|||
Hi,
This is a worksheet event code that may work when the data in "A1" changes. Paste this in the worksheet code module for the sheet that you named as "Names". Code:
Private Sub Worksheet_Change(ByVal Target As Range) Dim Mysheet As String If Target.Address = "$A$1" Then Mysheet = Target.Text Sheets(Mysheet).Activate Range("A1").Select End If End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a New Sheet from Existing Sheet with Specific Columns | malam | Excel Programming | 1 | 10-17-2014 10:01 PM |
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. | rogcar75 | Excel | 3 | 08-28-2014 05:21 PM |
Moving cell content without moving borders & shading? | unittwentyfive | Excel | 1 | 10-25-2013 12:56 PM |
Moving Duplicate records to new sheet | Woolstar | Excel Programming | 5 | 01-16-2012 01:46 AM |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |