Hi All,

I've created a Userform that captures the information inputed in the
textboxes and places them in a specific row on the excel spreadsheet.

The problem is when I created a subform attached to this userform. I
need the inputs on the subform textboxes to end up on the same row
that the information was placed by the original userform. How do I do
that?

Example:
Form 1 has Textbox1 and inputs its value in cell(Selected Row,
Selected Column)
its Subform1 has another Textbox1 where I want its input to be placed
in Cell(same row, next column) on same sheet.

I appreciate any help
Pantelis

Seems to me you would do it exactly the same way you are doing it with the
original form.

Regards,
Tom Ogilvy

"Pantelis" wrote in message
om...
Hi All,

I've created a Userform that captures the information inputed in the
textboxes and places them in a specific row on the excel spreadsheet.

The problem is when I created a subform attached to this userform. I
need the inputs on the subform textboxes to end up on the same row
that the information was placed by the original userform. How do I do
that?

Example:
Form 1 has Textbox1 and inputs its value in cell(Selected Row,
Selected Column)
its Subform1 has another Textbox1 where I want its input to be placed
in Cell(same row, next column) on same sheet.

I appreciate any help
Pantelis