Thread: return filename
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Joanne Joanne is offline
external usenet poster
 
Posts: 121
Default return filename

Thanks for the pointer Chip
Chip Pearson wrote:

Joanne,

The ListIndex property returns the 0-based number of the item in the list.
To get the actual value, use the Value property of

With lblVendor
fname = .List(.ListIndex)
End With