Populate Excel table with userform data

**waspandbee** · 07-20-2010, 04:23 AM

Hi,

I need help. I'm trying to populate an excel table with userform data. The table in excel actually occupies F31:O1048576. I need all rows except headers to have the same colour.

So is there a way to input data into the table while maintaining that every row has the same colour?

Attached is how the table looks like.

**royUK** · 07-20-2010, 05:12 AM

There's no UserForm

**waspandbee** · 07-21-2010, 01:19 AM

OK. User form is here.

**royUK** · 07-21-2010, 03:11 AM

I don't understand what you are doing,but the problem of formatting in 2007 would be easy to solve if you made the range into a Table.

Suggetion:
Don't merge the cells
Don't Select & Activate

**waspandbee** · 07-21-2010, 09:34 PM

But when the range is made into a table, there will be small triangular things beside each of the heading, this is for filtering I believe. How does one get it out?

And the thing is that data from the userform is suppose to be input into the table. The problem is not this.

The problem is that when the data creates a new row on the table, it appears without colour. It is suppose to bear the same colour as the row above it. It turns out white, not in light blue.