Table into a form

  • Thread starter Thread starter Kiran Vinta
  • Start date Start date
K

Kiran Vinta

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
 
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").value2

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to maintain dynamic data range for Excel PivotTable 4
How to export table from outlook into ms access table? 0
How to a Time planning into pivot table . 1
Remove all column and row fields from a pivot table 1
Copy to a Word Table 5
VBA - retrieve data on last create named range from previous inserted named range 0
Data Field in Pivot Table 3

Back
Top