VB Code Help

[cocoonfx]

Hi


I am developing a little spreadsheet where i have a worksheet where i have a list of names. When i new name is added a new worksheet is inserted into the workbook with the new name.

i.e

if Joe Bloggs where added a new worksheet will be added called Joe Bloggs.

I want to do this in VB script does any one know any useful tutorials?

 

[shades]

Howdy. I assume that the new name will go to the end of the list. As a starting point, record a macro to add a new worksheet and rename. See what code is produced. Then we can work from there.
________
Honda Civic (Seventh Generation) Specifications

 

[cocoonfx]

Hi


I found a site after hours of searching which put me in the right direction. I am picking VB up very slowly. I have uploaded an example so know one else goes through the pain of searching.

Basically you add a value to the sheet in A1 and it will change the worksheet to the value you entered.

My next challenge is creating a if statement into a macro.....