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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
How to use multiple command button to copy user form data to multiple worksheet 0
Counting multiple memberships 1
help with a basic code? 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Data validation on multiple worksheets in the same workbook 1
To protect user's privacy 1
append multiple worksheets data into a single multi-dimensional array 4

Back
Top