|
Subject:
|
adding new worksheet using user form
|
|
Posted By:
|
sime_tyres
|
Post Date:
|
2/20/2006 10:10:18 PM
|
i'm using microsoft excel2003
how am i going to adding new worksheet using button in user form..
for example..when i click button new record, it will automatically insert in new sheet..like each person has it's own sheet..
then..and all the data will insert in the new sheet..if the attribute are age,name and address.
|
|
Reply By:
|
echovue
|
Reply Date:
|
2/20/2006 11:35:48 PM
|
I am sure someone else will have a better way of doing this, but whenever I run into a problem like this I have a little trick I use, that will probably help you...
Go to Tools, Macros, and then choose Record a New Macro. Once the Macro has started recording, make a note of what it calls the macro, then do the steps you would like to have the VBA module do. In this case, insert a new sheet, rename it and add some data. Then stop the recording.
Now goto the VBA editor, and view the last Module under the modules section. The new macro will be under here, and will show you the steps that you need to follow to duplicate this. Rewrite it, change what you need to, and then assign your button to use the new Macro.
Hope that helps,
Mike
Mike
EchoVue.com
|
