Inserting a table into a module - Help please

[alfieuk]

Hi I know this is really a question for VBA and to be honest I have posted there but no one has answered.

So does anyone know how i can insert a simple 5x5 table into a vba module. I have created the basic html but i get a huge gap at the top, i think its known as white space? :/

Anyway this must be easy but its driving me insane now.

All i want is a grid/table that i can manually update with some info.

Any help on how to get rid of this gap would be hugely appreciated :)

[bobster65]

Hi I know this is really a question for VBA and to be honest I have posted there but no one has answered.

So does anyone know how i can insert a simple 5x5 table into a vba module. I have created the basic html but i get a huge gap at the top, i think its known as white space? :/

Anyway this must be easy but its driving me insane now.

All i want is a grid/table that i can manually update with some info.

Any help on how to get rid of this gap would be hugely appreciated :)

First off, there are 3 different module types in vbadvanced (BBCode, Template and PHP). Which one did you create and are having the problems with.

I would suggest using a Template Module to accomplish this.

Create a new Template Module.

In the box to post the template code, make sure that you wrap it with a table row and table data tag.. ie

<tr><td class=alt1>

INSERT YOUR TABLE CODE HERE

</td></tr>

you MUST wrap the code with the TR and TD tags for it to work properly (this is the single biggest mistake people make when using Template Modules with CMPS)..