I have acquired the following code to scan through a workbook to list all
the sheetnames and this works fine.
For SHT = 1 To ActiveWorkbook.Worksheets.Count
I am a relative beginner to VBA and am having trouble trying to get this information into a listbox so that a particular sheetname can be selected.
Could some kind programmer out there provide me with an example XLS
containing the code to perform this operation.
I can drag and create a listbox on an excel sheet, but I cannot go any further
in naming it or adding data to it.
I can also create a listbox on a userform in VBE, but again I cannot get it to
display with added items in it.
Your help will be greatly appreciated, as the frustration that this apparently
simple task is causing, is not doing my blood pressure any favours !