Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to a specific place in a document | Excel Worksheet Functions | |||
Import data to specific cells for a specific row | Excel Discussion (Misc queries) | |||
Need to remove text in specific place | Excel Worksheet Functions | |||
Formula to place the same value in a specific number of cells | Excel Worksheet Functions | |||
How to place a colored rectangle BEHIND some data cells? | New Users to Excel |