Hi guys,
I'm very new to VB. I recently made an application using Case selects and it worked fine. My aim is to now make an similar application but instead of using case select I want it to "browse" for an excel-file I have and show those outputs in an textbox.
Simple example:
City north = New York
City south = Oklahoma
Street north = Manhattan
Street south = Tulsa
In the form you can select the City or Street (using Combobox)
And you can select north or south(in another combobox)
After you select e.g City and north, he must look in the column of the Excel with "City" labeled e.g "A" and than check in the row with "north" labeled e.g. "1" and give the contents of A1 : "New York" and then bring this back to a variable which will be displayed in a textbox.
Can you help me on this one?
Thx,
Dennis FoendoePosted Sep 20, 2010, 10:11 PM
Hi guys, I'm very new to VB. I recently made an application using Case selects and it worked fine. My aim is to now make an similar application but instead of using case select I want it to "browse" for an excel-file I have and show those outputs in an textbox. Simple example: City north = New York City south = Oklahoma Street north = Manhattan Street south = Tulsa In the form you can select the City or Street (using Combobox) And you can select north or south(in another combobox) After you select e.g City and north, he must look in the column of the Excel with "City" labeled e.g "A" and than check in the row with "north" labeled e.g. "1" and give the contents of A1 : "New York" and then bring this back to a variable which will be displayed in a textbox. Can you help me on this one? Thx,