Create a form in different sheet than that of the data sheet

[Ramesha]

Hi friends,

I, want to have form in a different sheet than the one the data to be populated! your help appreciated, I'm not able to upload the macro enabled excel sheet.

Thanks

Ramesha

 

[chirayu]

You'll need to tell it to paste in a different sheet by using the Worksheet function. So code would be something like below. I can't really give you a better answer without having a sample.

Worksheet("Sheet2").Range("A1").Value = Userform1.Textbox1.Value