Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet
try......
Worksheets(LSV.Value).Select -- Cheers Nigel "tjh" wrote in message ... 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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet
Thank You for your responses.
I may have needed to include a little more in my question. It is still not working. The listbox is a multiselect and it loops through for as many sheets as are selected in the list box -- Is there a property that I may not have selected correctly??? Below is a shortened down version of the code, but I think it will show you how it is functioning: Private Sub CommandButton1_Click() E1.Hide Dim X As Long For X = 0 To LSV.ListCount - 1 Worksheets(LSV.Value).Select Range("A1").Value = LSV.Value Next X Unload E1 End Sub Private Sub UserForm_Initialize() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets Me.LSV.AddItem wks.Name Next wks End Sub Let me know if you need more info. Thank You, "Patrick Molloy" wrote: 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, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet
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 | |
|
|
Similar Threads | ||||
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 |