http://www.dailykitten.com/chat/ Daily Kitten Chat Forum Topic: Having serious problems with VBA for Excel en Tue, 14 Feb 2012 17:21:53 +0000 http://www.dailykitten.com/chat/topic/20898#post-444203 Tue, 08 Sep 2009 23:04:04 +0000 owlwatcher_974 444203@http://www.dailykitten.com/chat/ <p>BTW, those pictures of your cats with the ladybug caps are hilarious! </p> http://www.dailykitten.com/chat/topic/20898#post-444202 Tue, 08 Sep 2009 23:03:08 +0000 owlwatcher_974 444202@http://www.dailykitten.com/chat/ <p>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. </p> http://www.dailykitten.com/chat/topic/20898#post-444199 Tue, 08 Sep 2009 22:55:35 +0000 spanky_mouse 444199@http://www.dailykitten.com/chat/ <p>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 </p> <p><a href="http://www.excel-vba.com/" rel="nofollow">http://www.excel-vba.com/</a> </p> http://www.dailykitten.com/chat/topic/20898#post-444197 Tue, 08 Sep 2009 22:51:49 +0000 owlwatcher_974 444197@http://www.dailykitten.com/chat/ <p>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. </p> http://www.dailykitten.com/chat/topic/20898#post-444195 Tue, 08 Sep 2009 22:46:07 +0000 spanky_mouse 444195@http://www.dailykitten.com/chat/ <p>Could you do the basic formula for area and then divide by 9</p> <p>Area of rectangle is length x width<br /> There are 9 square feet to a square yard</p> <p>EXAMPLE - say a rectangle is length of 6 feet and a width of 6 feet - 6*6=36<br /> then to convert to sq yards divide 36 by 9 </p> <p>Hope this helps and works for that matter </p> <p>good luck </p> http://www.dailykitten.com/chat/topic/20898#post-444185 Tue, 08 Sep 2009 22:24:40 +0000 owlwatcher_974 444185@http://www.dailykitten.com/chat/ <p>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.</p> <p>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. </p> <p>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. </p>