| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table into a form
Currently, I have a table in an excel spreadsheet. It is not a
pivottable but rather a regular table with about 6 rows and 9 columns. I am trying to display this data in a simple form using vba. Any help will be much appreciated. -Kiran |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Table into a form
I do something similar to what you want from
the "Activate" event for the form in question. for each field do something like the following: fieldname1=worksheets(1).range("cellreference").va lue2 where cellreference would be "A1", etc. depending on where the data is in your spreadsheet. If the data location is dynamic, it will take a little more work. Hope that helps! Kevin -----Original Message----- Currently, I have a table in an excel spreadsheet. It is not a pivottable but rather a regular table with about 6 rows and 9 columns. I am trying to display this data in a simple form using vba. Any help will be much appreciated. -Kiran . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Fill In form that populates a table | Excel Discussion (Misc queries) | |||
| Need Formula Help Form Table | Excel Worksheet Functions | |||
| Set Pivot Table Tabular Form to Default | Excel Discussion (Misc queries) | |||
| PIVOT TABLE FROM A FORM IN ACCESS | Excel Discussion (Misc queries) | |||
| table or something. form? Template? | Excel Discussion (Misc queries) | |||
Linear Mode
