Name a sheet after a cell value

[sogeo]

Hello,

I was wondering whether is is possible to give a sheet the name of a value in a cell.
i.e.: I have written "test" in A2. Now I want the name of the sheet to be "test". But when I change the value of A2 to "edited", I want the name of the sheet to change automatically to "edited".

(I use excel for Mac)

Thanks in advance,

Sogeo

[apo]

Hi..

You need to add some code to the Sheet Change Event...

Please Login or Register  to view this content.

[sogeo]

It doesn't seem to work? I added the code into the VBE of that particular sheet.

[apo]

Hi..

Is it the first sheet in your workbook?

If not.. change the Sheet(1) part to suit..

[AB33]

Put this code in a sheet where ever your data in B2 are.

Please Login or Register  to view this content.

[sogeo]

Hmm, I can't get it to work.. (I haven't used VBA ever before).
Could anyone tell me what I'm doing wrong?

I added the workbook as an attachment.

(It's the first sheet that needs to change it's name automatically to the value of cell C2)

[AB33]

You have my code twice, one on the module and the other on sheet1. Please remove it from the module, so have only one in sheet1. I have tried and works for me. I do not know why it does not work, is it because you have a mac? I do not know.

[sogeo]

Hmm weird. Deleted the module now but still doesn't work.. It's probably because I'm on a mac?

[AB33]

It also may be your events have been disabled. I do not know what key stroke you use in mac,but in window while your cursor is at sheet1, CTRL+ G, will open a new window, or go to menu- view-select immediate window. While you have this window, type
application.EnableEvents=True
and hit the enter(Ok), then go back and try to change the value in C2 and see if this works.

[sogeo]

It works now, thanks for the help guys!