macro

[d_kight]

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

 

[Chip Pearson]

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[CLR]

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

 

[d_kight]

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

 

[d_kight]

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

 

[Dave Peterson]

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.)

 

[d_kight]

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.

 

[d_kight]

Hey Guys! it worked, I had a slight Typo. Look at me looking silly.
Thanks. Now on to some more complicated functions.

 

[Gord Dibben]

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

 

[Dave Peterson]

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.

 

[JLatham]

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