Microsoft Excel VB Code

[awebste]

Hey Everyone!

I am in the process of programming financial software, and my experience with Visual Basic is very limited. I have been trained in HTML/CSS and am now trying to learn Visual Basic on my own. I have been struggling with one thing in particular with my software and if anyone can help I would greatly appreciate it.

Basically what I am trying to do is in excel I have created a Client Summary - a place where all your information can be input (See attached spreadsheet). I want to be able to save that information to a listbox and be able to access it from the listbox everytime I open excel. In essence, I want to be able to make the Client Summary a template, be able to enter in numerous clients information and have it be saved into the listbox for future reference.

Hopefully I am explaining this right....like I said, I am new to the Visual Basic World. Hopefully the file I have attached explains what I want to do in itself.


Thanks so much!

 

[SkipVought]

Hi,

Sorry, can't LINK to your PC hard drive.

Put the new entries in a RANGE in Excel. I like to use Named Ranges. Link the range to your ComboBox ListFillRange property. If it's a Named Range, you never have to adjust your code.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[awebste]

bahaha

sorry i realized that after i pressed submit