single user form with multiple worksheets
 

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.

single user form with multiple worksheets
 

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.