Automatic naming of tabs?

[Excel Query]

I am building a worksheet for paying vendors for my company. Upon receiving a small batch of bills, I'll open a workbook that has several identical blank forms. For each bill, I'll fill-out one sheet within the workbook using a drop down list to insert the vendor's name/address. Then I'll fill in the the dollar amount of the bill.

Now my question: Once a vendor is chosen, is there a way for the generic worksheet to have the tab automatically filled-in to match the vendor's name. Is this possible? I'm a noob to VBA, so if that is necessary, I'll be struggling to understand.

Thanks for any help you can offer.

[Excelenator]

Copy this code and paste it into the Sheet object in the visual basic editor. To get there right click on the sheet tab and select view code. ONce there paste this code in. When you change the value of cell A1 the worksheet tab name changes. You can adjust the cell that changes the worksheet name by changing the red text in the code to the cell value you want with the $ included.

Please Login or Register  to view this content.

[Excel Query]

Thanks, that worked great. It popped in the word "New" before the name, so I deleted that from the code and it appears to still work fine.


And one other question to anyone who sees this. Where is the best place on this forum to start learning lots more about the visual basic editor?

[Mark K]

And one other question to anyone who sees this. Where is the best place on this forum to start learning lots more about the visual basic editor?

The Excel Programming forum would probably the best place to start.

[funkymonkUK]

And one other question to anyone who sees this. Where is the best place on this forum to start learning lots more about the visual basic editor?

and of course from me

[Excel Query]

Excelenator,
The code works great, but stops working if the sheet is saved. What can I change on the code so it continues to work?


BTW, thanks Mark, thanks funky.

[DCSwearingen]

I purchased a couple of books several years ago from Microsoft Press.

Both started bery basic and worked through to quite a bit more advanced.

Microsoft Excel97 Step by Step - came with a floppy with practice files to go along with the tutorials in the book.

Microsoft Excel97 Visual Basic Step by Step - Came with a CD with practice files to go along with the tutorials in the book.

I haven't looked recently, but I am sure they have somnething similar for today's products.

The Excel Programming forum would probably the best place to start.

[DCSwearingen]

http://www.microsoft.com/MSPress/books/5163.asp

Thanks, that worked great. It popped in the word "New" before the name, so I deleted that from the code and it appears to still work fine.


And one other question to anyone who sees this. Where is the best place on this forum to start learning lots more about the visual basic editor?