I'm having trouble adding the names of my worksheets to a listbox in a
userform I have created.
Dim item
Dim frm As New BatchPrintForm
For Each item In ThisWorkbook.Sheets
With frm.SheetList
.AddItem (item.Name)
End With
Next item
If I put "MsgBox(item.Name)" after the line that reads "For Each item
In ThisWorkbook.Sheets" the
message box shows the name of the worksheet currently being
processed. However, putting
"MsgBox(frm.SheetList)" After the line that reads ".AddItem
(item.Name)" shows me an empty message box
which reflects what I get in my listbox after compiling.
Any help would REALLY be appreciated.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
