Hi Rohit
Refer the below link by Debra Dalgleish for detailed help.
http://www.contextures.com/xlUserForm01.html
AND for your requirement replace the below line of code
Set ws = Worksheets("PartsData")
with
Set ws = Worksheets(Me.cmbSheets.Text)
where cmbSheets is the combobox which has got the sheet name
--
Jacob
"rohit" wrote:
Pl help. I want to use single user form for data entry to multiple worksheets
in a single workbook. The form has one dropdown list with each name in the
list having corresponding worksheet, to which all data should be posted.