Thread: Listbox in VBA
View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default Listbox in VBA

Hello,

I have this VBA macro:
fname = Application.GetOpenFilename
Workbooks.Open Filename:=fname
Set wb = Workbooks.Open(Filename:=fname)
I'd like to know whether it is possible with VBA to display all the
worksheets in workbook "fname" with a listbox in order to be able to click on
the worksheet that I want to activate ?
Regards,