Hey Steve,

Thanks for reply.

Yes, I need the all 105 columns.

As for looping, only to populate the 105 TextBoxes.

As for confusing to look at - I only look at the 3rd column by
adjusting the ComboBox1 ColumnWidths property = "0 pt;0 pt;474 pt".
474 is also the width of ComboBox1.

I finally found a work around by reloading ComboBox1 after putting the
name only into the proper cell and then sending the focus somewhere
else (the work around) and then bring it back to the original page.

If you still want to see the code, let me know. I am willing to share
it, there are quite a few subs involved.

It was while trying to explain what I was trying to do, that the
solution hit me.

Again, thanks

-Minitman



On Tue, 2 Sep 2008 12:46:20 -0700 (PDT), Incidental
wrote:

Hey Minitman

I am a little confused as to what you are trying to actually do? As
posted by Dave do you need all the columns? when i set up a test sheet
with it all that data in a single combobox it was very confusing to
look at. Perhaps you could include some code and some more
information on what you are doing. i.e. are you wanting to loop
through multiple ranges adding data to each of them. Keeping track of
all 105 columns will be very hard on the eyes but that's only my
opinion. You mention 105 textboxes also, would i be right in thinking
you load all your data to the combobox and then make a selection in
that control to display data in the 105 textboxes on the form?? I
don't know i'm just guessing now but i will try and be of help to you
if you can clarify things a little more.

Cheers

Steve