How to change the worksheet from Userform

[haridevadiga]

Dear User,

Hi, I have one query regarding to change the worksheet using userform.

For Eg:

I have two worksheet Sheet 1 "GI User" & Sheet 2 "HB User".

GI User Sheet
First Name
Last Name
Date of Birth
Birth Place

HB User Sheet
First Name
Last Name
Date of Birth
Birth Place

I have one userform which have above mentioned field : First Name, Last Name, Date of Birth, Birth Place. Now wht i want is, myself can put data using that userform in both the sheet, not at a time, i should get a option to select the one sheet at a time.

Waiting for reply,
Harindra D

[CreganTur]

Are you wanting to write this data to an Excel worksheet, or do you mean that you want to write the data to an Access Table?

Please clarify your question.

[haridevadiga]

Above mentioned data is in Two Different Sheet, having same field. . And now wht i want is a from one userform i can input a data in both the sheet one by one... (For Eg.. If i choose to input a data of GI i will choose GI User Sheet)