Macro to fill up a table from a User Form information

**diego0810** · 07-30-2012, 12:53 PM

Hello Everyone,

I have found this forum really helpful, and I have decided to join. I have a question. Any help is very much appreciated.

I have an excel table that contains many columns with different information that is imported from a macro User Form. The problem that I found is that if I add more columns in between, I have to go and change all the row-column references. This is basically what I have:

Please Login or Register  to view this content.

This code is simple. Just saves whatever is written in the form's text box, combobox, etc to the excel sheet. I think the easier solution is to define a table, then name the columns to make them absolute references, so if I put cells in between, it wont enter the info in the wrong column. The problem is that I haven't found the way or probably I am trying to apply a wrong concept.

I will greatly appreciate your help

Thank you.

Diego C.

**rvasquez** · 07-30-2012, 01:36 PM

Could you upload a sample of your workbook? I'm not sure absolute reference but I think you could use find method to find a header row.

Thanks!

**diego0810** · 07-30-2012, 02:00 PM

Thank you rvasquez. I will upload it.

What I am trying to do, is to keep the data going to the correct columns even if I add more columns in between at a later time without going to the VBA code and change all the references.

Thank you!

Diego C.

**rvasquez** · 07-30-2012, 02:24 PM

Hello there,

Attached is your original workbook updated to include some code at the beginning of your on save button click event.

Try it out and let me know if it works for you.

**diego0810** · 07-30-2012, 02:39 PM

Thank you rvasquez. I really appreciate it. I didn't think of that as a solution. It works perfect. Thank you!

Diego C.

**rvasquez** · 07-30-2012, 02:44 PM

No problem.

**diego0810** · 07-30-2012, 02:51 PM

Do you know if instead of looking to match the Text in the cell, could I check if matches the name of the cell?

Macro to fill up a table from a User Form information

LinkBack

Thread Tools

Rate This Thread

Display

Macro to fill up a table from a User Form information

Re: Macro to fill up a table from a User Form information

Re: Macro to fill up a table from a User Form information

Re: Macro to fill up a table from a User Form information

Re: Macro to fill up a table from a User Form information

Re: Macro to fill up a table from a User Form information

Re: Macro to fill up a table from a User Form information

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions