Re: Lists in Visual Basic


b...@xxxxxxxxx menuliskan:
Hi there,

I'm working in Excel 2002, SP3.


I have the data with the following format -


APC (Name : APC77) (Value : 200)
APC (Name : APC3157) (Value : XXX)
APC (Name : APC1406) (Value : 2000)
APC (Name : APC1426) (Value : 90)
APC (Name : APC74) (Value : 250)
APC (Name : APC3680) (Value : 10)
APC (Name : APC3683) (Value : 100)


BPC (Name : 3318) (Value : A) (Desc : (old))
BPC (Name : 3143) (Value : A) (Desc : (new))
BPC (Name : 3526) (Value : A) (Desc : (new))
BPC (Name : 3678) (Value : A) (Desc : (new))
BPC (Name : 3131) (Value : A) (Desc : (new))
BPC (Name : 3244) (Value : B) (Desc : (old))
BPC (Name : 3334) (Value : A) (Desc : (old))


I wish to use two lists, one called APC_List and the second called
BPC_List. I'd like to use the name as a key to the Value and Desc, if
possible. What datatypes might I use to achieve this,


Thanks for your help,


Barry

i think
Name ->string
APC Desc->String
BPC_Desc->bit (0 or 1)

how about that.. CMIIW.

regards

.

Relevant Pages

  • Re: Leading zeroes, text/numbers, import/export
    ... >If I want to do arithmetic, use a numeric format. ... >> We import into Excel and sometimes later export to ... >> can compare them from one list or sheet to another, ... Then, when comparing to other lists or exporting, ...
    (microsoft.public.excel.misc)
  • Re: Merging Excel to Word
    ... if all the date cells are formatted the same way but the Locale box says something other than "English " can you try ... in Format Cells, if you don't see "Date", then select Date, select the "English " locale, and select the format you want. ... Excel 2003 SP2 ... Service Pack 3 (SP3) now - you can get these packs from the microsoft web ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Leading zeroes, text/numbers, import/export
    ... If I want to do arithmetic, use a numeric format. ... So when I import a text file or create a file for myself, I can be consistent. ... > We import into Excel and sometimes later export to ... Then, when comparing to other lists or exporting, ...
    (microsoft.public.excel.misc)
  • Re: Quikbooks
    ... QuickBooks from Excel, provided they have the proper format. ... If you are looking to import lists into QuickBooks, ...
    (microsoft.public.excel.misc)
  • Re: Converting Numbers to Time
    ... Microsoft MVP - Excel ... I have to do calculations based on time. ... > lists. ... > Is it posible to take the NUMBER 10 and convert it to a MINUTE format? ...
    (microsoft.public.excel)