+ Reply to Thread
Results 1 to 4 of 4

userform combobox list link to sheets of different name

  1. #1
    Registered User
    Join Date
    10-02-2006
    Posts
    6

    userform combobox list link to sheets of different name

    I have a workbook with about 50 sheets and am trying to create a userform to fill in the required data within the sheets. each sheet is formated the same and the data well be placed in the appropriate sheet according the the selected name from the dropbox within the userform.
    The dropbox list contains names that are not the same as the sheet names, I need help in identifiing the sheet name from the dropbox list name.

    thanx

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Quote Originally Posted by brainfreez
    I have a workbook with about 50 sheets and am trying to create a userform to fill in the required data within the sheets. each sheet is formated the same and the data well be placed in the appropriate sheet according the the selected name from the dropbox within the userform.
    The dropbox list contains names that are not the same as the sheet names, I need help in identifiing the sheet name from the dropbox list name.

    thanx
    If I understand your problem correctly, you need to check out the RowSource property of the dropdown box within your userform. How is this being populated?

    Within the properties window, does it perhaps refer to a table held within the workbook which contains all the sheet names? And in which case how does this table get refreshed when/if new sheets are added? The safe way to ensure all sheets are included is to include some code in the initialisation event of the userform, which identifies all the sheets in the workbook and writes their values either directly with the .AddItem method, or indirectly by creating a list, and pointing the RowSource property to the list.

    HTH.

    Rgds

  3. #3
    Registered User
    Join Date
    10-02-2006
    Posts
    6
    the issue is not so much the list. it is getting the data to a sheet that is named different than the list from the dropbox. for example the droplist contains the name "application of compound". The data from the userform must then be entered onto a sheet named "02"
    thanx

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Do you really need 50 sheets? Can't you store the daat on one sheet as a database & fill a sheet with relevant information using VLOOKUP.

    If the names in the list don't match the sheet names then I would think the only option would be the ListIndex of the ComboBox perhaps match it to the sheet index.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

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