use VB to show data from excel?

[stupidboy]

Hi all experts, I recently doing some excel reporting, wonder if i can import all the data using VB and shows some report using the VB as well,
I briefly created a interface,


i also tried the way that you all taught me by applying the data into my VB program.
my question is, how do i code for if the drop down list that i selected, the name will be appear large in the frame box and will show the guys performance under there? (prefered in graph functions)

can i do something like pick a date as well? as u can see inside my excel file,
different date have different performance for everyone

can give me some opinion or sample code?

[zach007]

Hi,

I am not sure, and I am not an expert at all...but, please try this link. I wish this helps:

Click Here For Tutorial. (http://support.microsoft.com/default.aspx?scid=kb;EN-US;257819)

and also try this: Try this also. (http://www.freevbcode.com/ShowCode.asp?ID=7312)

;)