Daily Kitten Chat Forum » General Chat

1. 

   We are supposed to write a program that calculates the area of a rectangle when the length and width are input in feet. The answer is supposed to be converted to square yards.

   The book is no help at all as there are no solid examples of creating this kind of code then implementing it. My computer is not cooperating as I do not have a 'user defined' option in the functions list, nor will the computer create the required personal folder. I was not able to turn in my assignment tonight - which was worth 100 points, and I cannot find any help to put this assignment together.

   From what I have been told, there is no-one at the school yet to tutor in using VBA, and this instructor is the same person I had for excel a couple of semesters ago - the one who taught me less in 12 weeks than the other instructor taught me in three days! I am worried that I do not stand a chance in this class.

   Posted 6 months ago by owlwatcher_974 #

2. 

   Could you do the basic formula for area and then divide by 9

   Area of rectangle is length x width
   There are 9 square feet to a square yard

   EXAMPLE - say a rectangle is length of 6 feet and a width of 6 feet - 6*6=36
   then to convert to sq yards divide 36 by 9

   Hope this helps and works for that matter

   good luck

   Posted 6 months ago by spanky_mouse #

3. 

   It's not the formula itself that is giving me the problem so much as it is figuring out how to write the macro in Visual Basic. The book does not explain it in a way that I can understand it, and the instructor goes in circles while explaining things and is really of no help at all. He did give us instructions for the formula, but not how to incorporate it into the script or how to implement the script.

   Posted 6 months ago by owlwatcher_974 #

4. 

   ya I spoke to soon. I went online to redeem myself and found a site that has the what looks to be good info on vba

   http://www.excel-vba.com/

   Posted 6 months ago by spanky_mouse #

5. 

   Thanks for the link. It looks like it might have a lot of helpful info. I will study it tomorrow after I have had a good night's sleep.

   Posted 6 months ago by owlwatcher_974 #

6. 

   BTW, those pictures of your cats with the ladybug caps are hilarious!

   Posted 6 months ago by owlwatcher_974 #

RSS feed for this topic

Reply

You must log in to post.