Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Nevermind All, I got it
I should have been using LSV.List(X), rather than LSV.Value Thanks, "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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |