Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list related files, select which to open form
Hi everyone! I'm not even sure if this is possible, being that i am still fairly ne to excel VB. I am trying to code a form where the user selects a vendor then types in a claim number (or part of) and then presses ok. When th ok button is pressed the files which correspond to the query are show in the list box. file format: <vendor Claim <claim number.xls The user then selects the file from the drop down box and clicks th open files button. If someone could help me with this that would be great as I have loo everywhere that i know of. -- Sam The form looks like this: ------------------------------------------------------------------ Vendor: _<drop_box_ Claim number: _<Text_box_ <OK Button Files: ------------------------------------------------ | <list box | |_____________________________| <Open Files Button --------------------------------------------------------------------- -- Sami8 ----------------------------------------------------------------------- Sami82's Profile: http://www.excelforum.com/member.php...fo&userid=2711 View this thread: http://www.excelforum.com/showthread.php?threadid=46740 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: Can I open related files at one go ? | Excel Discussion (Misc queries) | |||
Multiple form files into one data list | Excel Discussion (Misc queries) | |||
How do you get outlook to select from list on a form | Excel Discussion (Misc queries) | |||
Select a category from a list that populates related cells | Excel Worksheet Functions | |||
when i open a excel doc , it open muiltple page not related? | Excel Discussion (Misc queries) |