Results 1 to 5 of 5

Textbox with multiple columns and rows using data from another sheet.

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2009
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    59

    Textbox with multiple columns and rows using data from another sheet.

    Dear Friends,

    I have macro to fill textbox in multiple rows and columns. This works only if data is in same sheet. But my data is in another workbook sheet which i need to be used to fill textbox.
    Can some one adjust my code to get data from closed workbook?

    (code which i use is as below. Sample of file is also attached)


    Private Sub UserForm_Initialize()
       
        'Set properties of listbox1
        With Me.ListBox1
            .BoundColumn = 1
            .ColumnCount = 3
            .ColumnHeads = True
            .TextColumn = True
            .RowSource = "Sheet1!A2:C15"
            .ListStyle = fmListStyleOption
            .ListIndex = 0
        End With
    
    End Sub


    Thanks in advance.
    Last edited by ali84pk; 10-17-2011 at 10:32 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