Conditional Statement In VBA

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I ended up with the code below, which seems to work okay. Thanks for the help. Now to the details.

1. The database is a table, how do I maintain the table as a table, if I post records to the bottom of the table with the shown code, it has some manually added records, those records no longer take on the properties of the table? Is there a way to force the table to remain a table after I post a record to it?

2. Secondly, how would I skip cells in the record, there are cells in the table that have vlookups and formulas in them that I would like to apply to the posted record. So I would like to post nothing in a column so I can use the table's formulas, then post the next form cell in the next database column.

3. How would I tell Excel which column to start entering the data from the form? Right now I'm sending a cell that is blank that goes into the first column. The first column is blank because I'm using Freeze First Column. The actual new record data starts at column 2.

4. Resize(1,13) Does the the 1 here determine how many copies to make of data?

Please Login or Register  to view this content.