Automatically rename worksheet when specific cell change

good afternoon,

I have the following code to update worksheet name based on cell "PURCH_TERMS"(=B3) which works perfectly i.e if B3 is empty then worksheet keeps original name, as soon as cell B3 is updated, worksheet is automatically renamed.

However if the user goes back to B3 and modify the data, I got an error message.......would it be possible to automatically update the worksheet name each time the data in B3 change (for info data in B is text and is manually entered or picked from a list)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

thank you in advance

Well no it rename the worksheet but not "purch" & seller.value & purch_terms.value, it name it "seller" only and when I change the "purch_terms.value" the worksheet name remain "seller".value only.

Then you just include the other parameters as strings i.e.

Please Login or Register  to view this content.

Or you can add the name string from another cell

Please Login or Register  to view this content.

Alf

it name the worksheet as soon as a value is entered in "b3" (like my code) however I would need if feasible, that if the content of cell "b3" is modified, the worksheet name is updated accordingly.

ex: if B2= "Y" and B3 = "X" then my worksheet is named PURCH Y X which works perfectly either with my code or yours
but if I go and change B3 to be B3="C" then I want the name of my worksheet to change to be PURCH Y C

This code is keyed to chang in cell B3 so perhaps this will give you what you wish for.

Please Login or Register  to view this content.

If you change the value in cell B2 nothing happends, if you change the value in cell B3 sheet name gets changed but if you only delete value in B3 sheet name stays the same.

Alf