 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2006macro
I am pretty new to using (or attempting to use) a Macro in a workbook. I am having trouble following how and what to do to even start the process; ie If there needs to be a worksheet already in progress or can I start from a new sheet. THEN where to go from there. Can I have some help in this area? Can some one supply me with a sample MACRO? Any help would be greatly appreciated Dan The best way to get started with macros is to use the Macro Recorder. Go to the Tools menu, choose Macros, then Record New Macro. Then, carry out some simple tasks and examine the code that is produced.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com >I am pretty new to using (or attempting to use) a Macro in a >workbook. I am [quoted text clipped - 11 lines] > > Dan Hey Guys! it worked, I had a slight Typo. Look at me looking silly. Thanks. Now on to some more complicated functions. > The best way to get started with macros is to use the Macro > Recorder. Go to the Tools menu, choose Macros, then Record New [quoted text clipped - 16 lines] > > > > Dan Check out these sites as a good place to start......... www.cpearson.com http://www.mcgimpsey.com/excel/index.html#usingvba http://www.mvps.org/dmcritchie/excel/excel.htm hth Vaya con Dios, Chuck, CABGx3 > I am pretty new to using (or attempting to use) a Macro in a workbook. I am > having trouble following how and what to do to even start the process; ie If [quoted text clipped - 7 lines] > > Dan Wow, Thanks you guys!The sites and the recorder information seem like they will do the trick for me learning to use macros. I will give tha ta go. Dan > Check out these sites as a good place to start......... > www.cpearson.com [quoted text clipped - 16 lines] > > > > Dan OK How about this error: I have tried an example of using a macro to find the area of rectangle. I made a function called area and here is the syntax I used in the Module: Function Area(Length as Double, Width as Double) Area = Length * Width End Function Then when I go to a worksheet, and place 17 in cell A1 and 10 in cell B1 and in C1 type in =Area(A1,B1) I expect to get 170, but I get 0 Am I missing something?? Please help. Dan > Check out these sites as a good place to start......... > www.cpearson.com [quoted text clipped - 16 lines] > > > > Dan Make sure calculation is set to automatic. tools|options|calculation tab And make sure you put the values in A1 and B1 and your function uses =area(a1,b1). (I'm suspecting that you didn't put the values in A1 and B1.) > OK How about this error: > I have tried an example of using a macro to find the area of rectangle. I [quoted text clipped - 30 lines] > > > > > > Dan SignatureDave Peterson Thanks dave BUT I have (or had) done everything that you mentioned and it did not work correctly for me; like put the values in A1 and B1, the calculation is set to auto, and the function is =area(a1,b1), I even started over. I also put that formula in c1 and the result I was given was 0. try it the exact way I did and see if you get the same results (to show I am not loosing it entirely). Does capitalization matter? Thanks for the response, Dave and let me know the results. > Make sure calculation is set to automatic. > tools|options|calculation tab [quoted text clipped - 38 lines] > > > > > > > > Dan I tested your UDF and followed your steps as below. C1 returns 170 or any other value depending upon A1 and B1 values. Capitalization does not matter. =Area(a1,b1) is good as well as =area(a1,b1) Gord Dibben MS Excel MVP >Thanks dave BUT I have (or had) done everything that you mentioned and it did >not work correctly for me; like put the values in A1 and B1, the calculation [quoted text clipped - 47 lines] >> > > > >> > > > Dan The only way I got 0 is if one of the cells (or both) I pointed at was 0. Everytime I used it, it worked fine. > Thanks dave BUT I have (or had) done everything that you mentioned and it did > not work correctly for me; like put the values in A1 and B1, the calculation [quoted text clipped - 51 lines] > > > > Dave Peterson SignatureDave Peterson I'm a little late to the party. But I thought I'd offer one more source. This page gives links to instructions for inserting general purpose VBA code, VBA code tied to a worksheet event and VBA code tied to workbook events. Thought it might help you in your learning: http://www.jlathamsite.com/LearningPage.htm > I am pretty new to using (or attempting to use) a Macro in a workbook. I am > having trouble following how and what to do to even start the process; ie If [quoted text clipped - 7 lines] > > Dan |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.