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.
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?
Originally Posted by brainfreez
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.
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"
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1