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

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

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