Re: Show Filename Only in ComboBox Pulldown

D,

Use the "Dir" function...
'-----------------------------
Sub FileNameTest()
Dim strPath As String
Dim strName As String
strPath = "C:\Program Files\Intel\Intel Application Accelerator\iATAenu.dll"
strName = Dir(strPath)
MsgBox strName
End Sub
'-----------------------------

Jim Cone
San Francisco, USA



"D.Parker" <DParker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:34C643D4-E029-4119-AE39-DCFA19A0A3BE@xxxxxxxxxxxxxxxx
This is an continuation post from 6/26. JMB showed me the code to add to
utilize FileSearch inconjunction with UserForms. The code works great,
unfortunately the entire "path" (C:\.....\<filename>.txt) shows up in my
combobox pull down. Is there a way to show only the filename and not the
actual path to the file in the combo box?

Kind regards,

D.Parker
.

Loading