Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB File Controls available to Excel VB?
Hi
Are the DriveListBox, DirListBox, and FileListBox controls, available i believe with VB (at least i see them referenced in a VB manual) somehow portable for use while doing VB macro programming in Excel 2002? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB File Controls available to Excel VB?
Yes they are. Go into the VBA: Tools-Macro-Visual Basic Editor. Then
Insert-User Form and an empty form and the pallette with List Box etc. will appear. In case you don't know, you drag them to the desired place on the empty form. But I am not going into it any more here as it's obviously a big subject. "Using Microsoft Excel97" by QUE, ISBN 0-7897-1399-3 at about £38 / $40 is quite a comprehensive book - but there may others which are just as good for your needs at a cheaper price. Best of luck with it. Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using controls with Excel 2003 | Excel Discussion (Misc queries) | |||
Controls not available in Excel. | Excel Discussion (Misc queries) | |||
No ActiveX controls when reading 2007 file formats into Excel 2003 | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Help on Excel controls | Excel Discussion (Misc queries) |