Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
edit & configure add button & code
is there anyone that can help resolve my problem what i trying to do is save
data from one worksheet to another using a button the the worksheet that i have created also use & edit & cancel buttons. i need to know how to write & edit macros pls help as i am running out of patience |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
edit & configure add button & code
Hi,
First you should realize that Excel's programming language is a full fledged programming language just like COBOL or C++. It takes years to become a programmer, it is not going to happen in a few hours. Start by buying a couple of books or VBA programming in Excel, such as Reed Jacobson's Step by Step and John Walkenbach's Power Programming in Excel. Take a couple of classes. Read the VBA help system, record macros, try to figure out what they are doing. Read other post on this site and figure out what they are talking about. Programming is not for everyone, in fact most people probably would hate it. If your loosing patients alread, your probably not cut out to be a programmer. We can only give you small steps (pointers) here at this site, because a 1000 page answer (that's about how long John's book is) just isn't what this site is all about, all that said, a starting place would be: Basically, turn on the recorded and do the steps you want, turn off the recorder and test. When the code doesn't do what you want post the code here and tell us what it is doing and what you want it to do. Start a recording by choosing Tools, Macros, Record New Macro. Do the steps, turn the recorder off. You can edit the macro by pressing Alt+F11, opening the Module folder attached to your workbook in the Projects area and double clicking module1. Also, you might consider posting programming questions to the Excel Programming newsgroup. Cheers, Shane Devenshire uk" wrote: is there anyone that can help resolve my problem what i trying to do is save data from one worksheet to another using a button the the worksheet that i have created also use & edit & cancel buttons. i need to know how to write & edit macros pls help as i am running out of patience |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
configure add button & code | Excel Discussion (Misc queries) | |||
edit configure add button and code | Excel Discussion (Misc queries) | |||
Edit this macro code to loop and end | Excel Discussion (Misc queries) | |||
Can't delete or edit control button | Excel Discussion (Misc queries) | |||
edit hyperlink code cont from 12/8/04 | Excel Discussion (Misc queries) |