ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   finding values and put them in a listbox on visual basic form (https://www.excelbanter.com/excel-programming/400968-finding-values-put-them-listbox-visual-basic-form.html)

Frank M

finding values and put them in a listbox on visual basic form
 
Hello,

i'm creating an visual basic form for an excel sheet that is being used at
my work. The sheet looks as followed:

colum A B C D E F G H I J
in/out | 20 || 30 || 40 |
20 A|S|D A|S|D A|S|D
30 |S|
40 |S| A| |D

the numbers horizontal are merged cells and the letters are hyperlinks to
other excel documents that contain data. lets say that the numbers are
different types of cars and that u can rebuild a car type to an other car
type. So when u want to rebuild a 20 car to an 30 car there are documents
available which gives u diffferent information (A-S-D).
My question: i want to create a list that shows the types of output that are
available when the user inserts a input. For example: When the user inserts
20 as input and 30 as output the documents can be opened form the visual
basic form with 3 different textbox's. But when the user inserts 40 as input
and 20 as output there will be no data available from the textbox's. now i
want to generate a listbox which say that there are documents available from
a 40 / 30 combination and a 40/40 combination. this list has to be made in
Visual basic.

I hope u can help me with this, perhaps vague, problem.



All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com