Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
one user form multiples worksheets | Excel Worksheet Functions | |||
User Form - use of single form for multiple sheets | Excel Programming | |||
Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
User form and hiding worksheets | Excel Programming | |||
Need to have multiple worksheets use a single worksheet | Excel Worksheet Functions |