?
Solved

name and numbers

Posted on 2003-03-30
8
Medium Priority
?
159 Views
Last Modified: 2010-05-03
hi i just want to most efficient (cpu and size) way of storing and retrieving a list of names and numbers

thanks!
0
Comment
Question by:FeVeR
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 

Expert Comment

by:kartik
ID: 8236850
Use VB collection.
0
 

Accepted Solution

by:
jazzzz20 earned 100 total points
ID: 8237403
Hi.

Use Dictionary object:



Dim d
Set d = CreateObject("Scripting.Dictionary")
d.Add "Name1", "Number1"
d.Add "Name2", "Number2"
d.Add "Name3", "Number3"

MsgBox "Number of Name2 is " & d("Name2")



Regards.

0
 

Author Comment

by:FeVeR
ID: 8242666
sorry, i need to be able to view them also, on a scroll bar type setup
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:jazzzz20
ID: 8244896
Hi FeVeR.

Actual question does not contain any such requirement. Therefore you should initiate a new question if you want its answer.

Regards.
0
 

Author Comment

by:FeVeR
ID: 8267994
are you serious?? sorry but no
0
 

Expert Comment

by:CleanupPing
ID: 8531288
Hi FeVeR,
This old question (QID 20568433) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 

Expert Comment

by:jazzzz20
ID: 8579971
Hi Moderators.

Please do not refund the points. FeVeR tried to change the question after receiving a comment/answer. Please see his/her comment of [ 03/31/2003 06:13PM PST ] and match it to the actual question. He/she extended a "hint" to a whole application after receiving a comment/answer.

I don't need the points but they should not be refunded to FeVeR because such behavior discourages people like me from answering the question because after commenting on it, the question's scope is extended which is totally unfair. I request you to discourage this type of behavior by canceling the points of FeVeR.

Regards.
0
 

Author Comment

by:FeVeR
ID: 8584163
technically you're correct. not exactly collaboration though. thanks jazzzz20.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question