i want to create a simple Listbox userform that shows all the worksheets in the active workbook with the worksheet number / name / whether or not visible
So far I have: (with a listbox called Lbx_Worksheets)
Private Sub UserForm_Initialize()
Dim i As Long
For i = 1 To ActiveWorkbook.Worksheets.Count
but this justs lists the items in one column.
Can anyone assist, please?
What is the syntax for showing if the worksheet property is hidden or visible?
I have set the columncount property to 3