Results 1 to 6 of 6

Userform displaying multiple worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2011
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    8

    Userform displaying multiple worksheets

    Hi guys,

    I have an excel table that contains many worksheets. I am trying to make a userform, which displays all the worksheet and let's you select which worksheet you want to open. So the userform should consist of listbox and button. I've made the listbox to display all the worksheet, but can't manage the button. Please help ...

    Here is the listbox configurationi:

    Private Sub UserForm_Initialize()
    
    Dim ws As Worksheet
    
    Me.ListBox1.Clear
    
    For Each ws In ActiveWorkbook.Worksheets
    
        Me.ListBox1.AddItem ws.Name
    
    Next ws
    
    End Sub
    Last edited by Fixa; 03-12-2012 at 08:24 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1