Hello all.

I am trying to setup a script where I can use a form (Userform1) to fill in
an employee name and ID number, click the ADD button and create a new
worksheet with the employees name only?

I've searched this group for similiar topics, but not fit exactly as I need.

Any suggestions?

TIA

Mark

In its simplest form the add sheet will create a new sheet and activate it,
then name it using the string which could come from the control on the
userform.
e.g textbox1.value

Sheets.Add
ActiveSheet.Name = textbox1.value

--
Cheers
Nigel



"Bruise" <(E-Mail Removed)> wrote in message
news:%23$(E-Mail Removed)...
> Hello all.
>
> I am trying to setup a script where I can use a form (Userform1) to fill
> in
> an employee name and ID number, click the ADD button and create a new
> worksheet with the employees name only?
>
> I've searched this group for similiar topics, but not fit exactly as I
> need.
>
> Any suggestions?
>
> TIA
>
> Mark
>
>

in the beginning of your userform command code, you just need to insert

Worksheets.Add
ActiveSheet.Name = "xxxx"


susan

Worksheets.Add.Name = TextBox1.Value

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bruise" <(E-Mail Removed)> wrote in message
news:%23$(E-Mail Removed)...
> Hello all.
>
> I am trying to setup a script where I can use a form (Userform1) to fill
in
> an employee name and ID number, click the ADD button and create a new
> worksheet with the employees name only?
>
> I've searched this group for similiar topics, but not fit exactly as I
need.
>
> Any suggestions?
>
> TIA
>
> Mark
>
>