This may seem rather trivial, but I would appreciate any help.

I am currently building a Word 2003 template. When the template is opened (new), a userform is initialised. Choices made within the userform will build the completed document using bookmarks.

Within the document I have a 1 row, 2 column table. I want to use the table to generate 2 lists of items - one in the left column and one in the right column (it is in fact one list, but I am separating into 2 columns for spacing). Each item in the list needs to be in its own cell. Before the user has made any choices I do not know how long the list will be, although I know there will be at least one item.

In the first cell is a bookmark, from which my list begins. The first item is entered based on a user choice. The remaining items may or may not be entered so for each option that is selected I have created a string which is in the format:

VB Code:
  1. strOption02 = vbTab & "Some text"

If the option is not selected then the string is nothing.

When the userform information is submitted, I then have:

VB Code:
  1. .Bookmark("Table1Cell1").Range.Text = strFirstItem & strOption01 & strOption02.....& strOption50

Any strings that are null are ignored so the table does not expand beyond the size it needs to be and the length of the "2" lists would be the same or worst case, the left column would have one entry more (or at least that was the plan).

I was hoping that the vbTab would behave the same way as pressing the keyboard tab when in a table cell, i.e. tab to the next column or add a new row if already in the last column. As I'm sure many people know (except me of course), that doesn't work.

Assuming my explanation is clear, can anyone offer any advice or direction with what I am trying to achieve?

Thanks in advance.

PS. I have tried recording a Macro tabbing from cells and adding text etc but I don't understand the code enough to apply it properly (constant syntax errors).