single user form with multiple worksheets

  • Thread starter Thread starter rohit
  • Start date Start date
R

rohit

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.
 
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
 
Back
Top