What is a VBA?

I have opened a tab by right clicking it and clicking view Tab and C&P'd

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Const sNAMECELL As String = "A1"
Const sERROR As String = "Invalid worksheet name in cell "
Dim sSheetName As String

But when i hit enter nothing happens?

Scoober


"Eduardo" wrote:

Hi,
in order to get the tab to be named according to a name entered in a cell
you need a VBA
Mc gimpsey tell you how to copy the code provided open the link from the
first paragraph tha says "Worksheet code module", it explain step by step
what to do

"Scoober" wrote:

dI'm not paticularly good with LX and did not understand a worg that that
link said.

I take it it is a little more than simply adding a foruula somewhere?
--


Scoober


"Eduardo" wrote:

Hi, take a look at Mcgimpsey web

http://www.mcgimpsey.com/excel/event...efromcell.html

if this helps please click yes, thanks


"Scoober" wrote:

Can a cell be used to name a worksheet.

e.g In A1 Joe Bloggs is written, is there formula that can name the
worksheet's Tab Joe Bloggs?
--
Thanks in advance.

Scoober