Adding new worksheet using VBA

  • Thread starter Thread starter wuming
  • Start date Start date
W

wuming

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
 
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
(e-mail address removed)
 
You must log in or register to reply here.

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

Excel VBA 0
Excel crashes and restarts when accessing newly created worksheet 2
To protect user's privacy 1
VBA Error Handling 4
How to use multiple command button to copy user form data to multiple worksheet 0
VBA - retrieve data on last create named range from previous inserted named range 0
How to assign a worksheet in VBA 3
Referencing command button on worksheet from VBA 3

Back
Top