Re: Display multicolumn box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows 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. Dick 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?
>

Relevant Pages

  • Re: LloydsTSB business account numbers
    ... have seven digit account numbers. ... zero, the next digit is 6 (it's a personal account though, not ... number is to add leading zeroes. ...
    (uk.finance)
  • Re: Weird Query
    ... I'd withdrawn $100 from the account and my receipt said I had $0.00 ... known zero value and an unknown value. ... there is a big *practical* difference between a known zero ... length string and an unknown string. ...
    (comp.databases.oracle.misc)
  • Re: Examples of SQL anomalies?
    ... repeatable balance month to month. ... There are months when the account ... But zero is not the correct answer to give your ... incompetent and naive users and managements who allow db developers to make up biz requirements don't help either. ...
    (comp.databases.theory)
  • Re: VBA Error
    ... Thanks for the advice-- hovering over txtHrs2 shows a zero as everyone ... the text box -- txtHrs2 shows on the Userform the correct entry of figures ... > TextBox is only accessible when that control has the focus. ...
    (microsoft.public.excel.misc)
  • Re: How can I keep a zero (0) at the front of a set of numbers.
    ... zero is NOT a number, it isTEXT. ... Excel to treat the characters as text. ... Format the cell as Text before entering the account numbers. ...
    (microsoft.public.excel.worksheet.functions)