Worksheet
did you know that if you have the tabs showing, then a right click at the
left side, over the left,right indicators, pops up the list of sheets?
"tjh" wrote:
Hello,
I am using a listbox to display all the worksheets in a file, I also have
the MultiSelect property set to Multiple selections.
On Initialize I am using the code below to populate the ListBox:
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
Me.LSV.AddItem wks.Name
Next wks
Then in the code that uses the worksheet name, I am using the below to
select the sheet but getting an Error:
Worksheets(LSV).Select
How do I fix this??
Thank You,
|