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 |
Place Subform data onto specific cells
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 |
All times are GMT +1. The time now is 05:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com