Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-30-2012, 08:43 AM
Jamtart Jamtart is offline Get Run-time Error 11 Windows 7 64bit Get Run-time Error 11 Office 2010 64bit
Advanced Beginner
Get Run-time Error 11
 
Join Date: Apr 2012
Posts: 53
Jamtart is on a distinguished road
Default Get Run-time Error 11


I cant figure out how to resolve this error. If I enter a value of 1 in the Angle box I get this error. Hopefully someone can see what to do
Attached Files
File Type: zip RL Circuit.zip (411.6 KB, 8 views)
Reply With Quote
  #2  
Old 08-31-2012, 12:27 AM
JohnWilson JohnWilson is offline Get Run-time Error 11 Windows 7 64bit Get Run-time Error 11 Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,912
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

Did you convert to Radians before finding the arcCos??

(sorry I'm a bit too busy to look!)
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 08-31-2012, 05:04 AM
Jamtart Jamtart is offline Get Run-time Error 11 Windows 7 64bit Get Run-time Error 11 Office 2010 64bit
Advanced Beginner
Get Run-time Error 11
 
Join Date: Apr 2012
Posts: 53
Jamtart is on a distinguished road
Default

Hi John, I used the script that you created for me a short while ago:
Function GetAngle(ThisCos As Double) As Double
Const PI As Double = 3.141592
Dim Acos As Double
Acos = Atn(-ThisCos / Sqr(-ThisCos * ThisCos + 1)) + 2 * Atn(1)
GetAngle = Round(Acos * 180 / PI, 2)
End Function


The radians convert stuff is all greek to me sorry to say, although I was doing some reading up on just that, figuring that is where the root of the issue is.
In the mean time I did create a work around by limiting the users input to no less than 5 degrees and no greater than 80 degrees. Anything less than 5 degrees will to cause that error.
The course content that is being addressed here is representing a coil, which would never have an angle anywhere near as small as 5 degrees or as great as 80, but rather somewhere in the middle.
The work around works, but does not make the value input the most user friendly for those that may use this other than me.
I will keep looking at this to make it work 100%, thanks for the feedback...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get Run-time Error 11 Run time error 1004 yonasan Excel Programming 3 06-12-2012 11:08 PM
Word Visual Basic error - run time error 504 crazymorton Word 11 01-13-2012 04:32 AM
Get Run-time Error 11 Error:Power point can't readthe outline from time-world.ppt.No text converter is inst aligahk06 PowerPoint 1 10-21-2011 03:48 AM
Get Run-time Error 11 Run-time error 438 cksm4 Word 2 01-12-2011 03:41 PM
Word: The document 'Filename' caused a serious error the last time ... martincruise Word 0 02-25-2010 01:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft