Excel: Array containing sheet names? 2

[ribsa3]

Hi

I wish to populate a combo-box with the names of all the sheets (Not the object name, but the object name's name - get it? - Basically the text on the sheet tab.

Is there a nice system array I can use to retrieve this data most conveniently?

Kindly,

Bjoern Sandvik



--------------------------------------------------------------------
Do what you wish, as long as it harms no one. That includes yourself.

 

[Molby]

Try this:

Private Sub ComboBox1_DropButtonClick()
Dim ws As Worksheet
ComboBox1.Clear
For Each ws In ThisWorkbook.Worksheets
  ComboBox1.AddItem ws.Name
Next ws
End Sub

 

[afryer]

Hi,

I'm not sure what you mean about the objects names name, but if you simply want to get the names as they appear on the screen then do the following:

For Each l_worksheets In Worksheets
    
    ' add your code her to add it to the combo
    
    MsgBox (l_worksheets.Name)
Next l_worksheets

Hope this helps

Andrew

 

[ribsa3]

I knew it had to be easy Thanks!



--------------------------------------------------------------------
Do what you wish, as long as it harms no one. That includes yourself.