Re: Display multicolumn box

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 03/12/05 

Date: Sat, 12 Mar 2005 15:56:48 -0500

also, I had some bad code in my original. I neglected to account for the
fact that the row references in list are zero based, so

      .listbox1.additem cell.Value
      .listbox1.list(.listbox1.listcount,1) = cell.offset(0,2).Value
      .listbox1.list(.listbox1.listcount,2) = cell.offset(0,5).Value

should be

      .listbox1.additem cell.Value
      .listbox1.list(.listbox1.listcount-1,1) = cell.offset(0,2).Value
      .listbox1.list(.listbox1.listcount-1,2) = cell.offset(0,5).Value

I did account for the zero base for columns.

Also, you posted this question earlier. *** Kusleika responsed to that
with a slighty different approach (using FIND) and wrote it as a userform
initialize event. so that may be easier for you to implement. 

-- 
Regards,
Tom Ogilvy
"Alen32" <bingo190@yahoo.com> wrote in message
news:667657256585427c1a1b983fc2c3fa00@localhost.talkaboutsoftware.com...
> Do I need make userform with listboxes?
>
Quantcast