Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding new worksheet using VBA
Hi,
How do u add a new worksheet to an existing workbook when lets say command button is clicked? The worksheet would then asked user to inpu data. Anyone knows -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding new worksheet using VBA
Wuming
This code in the Click event of a command button Private Sub CommandButton1_Click() Worksheets.Add End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "wuming " wrote in message ... Hi, How do u add a new worksheet to an existing workbook when lets say a command button is clicked? The worksheet would then asked user to input data. Anyone knows? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding several worksheet cells onto a main worksheet | Excel Worksheet Functions | |||
Adding Worksheet | Excel Worksheet Functions | |||
Adding worksheet tab names to the first worksheet | Excel Discussion (Misc queries) | |||
list worksheet macros/VBA without adding worksheet | Excel Discussion (Misc queries) | |||
Adding a worksheet | Excel Programming |