Put in the UserForm Initialize event code.

For Each sh In ActiveWorkbook.Sheets
If Not sh.Name Is Nothing Then
UserForm1.ListBox1.AddItem sh.Name
End If
Next

Untested.

"pswanie" wrote:

how do i list all the sheet tab names in the current workbook in listbox1?
the listbox1 is on userform1

thanx