Thank you to all who have helped me on this project so far. One more
question...
I have a ridiculously long array -- so long Word can't handle it.
I tried
Group1 = Array ( "A", "B", "C", "D")
Group2 = Array ( "E", "F", "G", "H")
GroupAll = Group1 & Group2
but it didn't like that... I also tried
GroupAll = Array (Group1, Group2)
No dice. What do I try now?
Thanks
JPJP
How long is ridiculously long? If this is associated with your population
of combobox issues, are the number of entries too long for the method that I
suggested? If so, there are probably too many selections for your users to
handle, let alone Word and you should try and split the number of items into
more categories and have the user first pick a category, then and item from
that category and then a sub-item from the item that they have picked in the
category.
For the guy whom I was helping in the link to which I directed you, a
modification of that method was use to deal with 4 or 5 levels of selection,
though, not because of the total number of items, but because of the desire
to categorise them at a number of levels.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> Thank you to all who have helped me on this project so far. One more
> question...
[quoted text clipped - 16 lines]
>
> JPJP
JGJP - 17 Aug 2006 12:56 GMT
Doug,
Too long is really just longer than Word will accept. I don't really
have a choice about breaking it up into categories because I'm making
it for someone else. It's not really that they have too many choices --
there were 24 - but there were too many characters. When I split it
into two lines, it accepted it. So is concatenation not feasible?
JGJP
> How long is ridiculously long? If this is associated with your population
> of combobox issues, are the number of entries too long for the method that I
> suggested?
....
--
> Doug Robbins - Word MVP
>
> "JGJP" <jeanne.goodman@gmail.com> wrote in message
> > I have a ridiculously long array -- so long Word can't handle it.
...
> > JPJP
Jonathan West - 17 Aug 2006 13:19 GMT
You can split a line of code into two lines, like this
Group1 = Array ( "A", "B", "C", "D", _
"E", "F", "G", "H")
By splitting into as many lines as you require using the line continuation
character, you can put many more terms into the array.
Make sure always that there is a space before the line continuation
character.

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
> Doug,
>
[quoted text clipped - 19 lines]
> ...
>> > JPJP
JGJP - 17 Aug 2006 15:02 GMT
Silly me! I forgot about that! Thank you!
JG
> You can split a line of code into two lines, like this
>
[quoted text clipped - 13 lines]
> Please reply to the newsgroup
> Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org