Thread: .additem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
 
Posts: 1
Default .additem

You have to tell it what to add. Here is some code that works :-

'------------------------------------------------------
FindForm.BookCombo.Clear
For Each wb In Workbooks()
FindForm.BookCombo.AddItem (wb.Name)
Next
'------------------------------------------------------------

--
Message posted from http://www.ExcelForum.com