Change target cell automatically

Praxis · May 22nd, 2002, 05:12 PM

Does anyone have a VB Code to change a target cell, Lets say $C$3,..automatically by changing the worksheet tab name.

Al Chara · May 22nd, 2002, 05:15 PM

Can you try and explain that a little clearer.

Praxis · May 23rd, 2002, 06:43 AM

Sure...

You know how Excel have the Sheet tabs on the bottom (Sheet1,Sheet2,Sheet3)...

Is it possible that when I rename the sheet tab..Lets say Sheet1, that it would automatically change a cell value in a worksheet..Lets say $C$2.

Asala42 · May 23rd, 2002, 06:49 AM

Hey,

Probably a quicker way but how about a custom function:

Code:

Function sheetname()
sheetname = ActiveSheet.Name
End Function

In C2 type in the formula:

=Sheetname()

Adam

May 23rd, 2002, 06:49 AM	#4
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hey, Probably a quicker way but how about a custom function: Code: Function sheetname() sheetname = ActiveSheet.Name End Function In C2 type in the formula: =Sheetname() Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 05:12 PM	#1
Praxis Board Regular Join Date: May 2002 Location: Minnesota, USA Posts: 70	Does anyone have a VB Code to change a target cell, Lets say $C$3,..automatically by changing the worksheet tab name.

May 22nd, 2002, 05:15 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Can you try and explain that a little clearer.

May 23rd, 2002, 06:43 AM	#3
Praxis Board Regular Join Date: May 2002 Location: Minnesota, USA Posts: 70	Sure... You know how Excel have the Sheet tabs on the bottom (Sheet1,Sheet2,Sheet3)... Is it possible that when I rename the sheet tab..Lets say Sheet1, that it would automatically change a cell value in a worksheet..Lets say $C$2.