Prev: Redirect Selection in Cell to Print Job
Next: minimize workbooks in macro
From: rohit on 29 Jan 2010 01:16
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.
From: Jacob Skaria on 29 Jan 2010 01:45
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.
 | 
Pages: 1
Prev: Redirect Selection in Cell to Print Job
Next: minimize workbooks in macro