View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pantelis pantelis is offline
external usenet poster
 
Posts: 27
Default Place Subform data onto specific cells

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