single user form with multiple worksheets

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.
 
J

Jacob Skaria

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
Data validation on multiple worksheets in the same workbook 1
help with a basic code? 0
Plot graph depending on drop down box selection 1
append multiple worksheets data into a single multi-dimensional array 4
To protect user's privacy 1
Formatting and copy or copy and formatting ?? 2
Excel 2011 Mac - Import Worksheets into a Single File 0

Top