A ricocheting ball with VBA

[Worf]

Worf submitted a new Excel article:

A ricocheting ball with VBA - This article calculates the path of a ricocheting object inside a closed 2D area.

Using trigonometry, it is possible to calculate the path an object will follow when hitting the inside walls of a closed rectangular area. Here are the relevant points of the code:

• The input variables are the starting position and angle, between 1 and 89 degrees. The values are hardcoded but this is easily modifiable.
• Basically, the code finds the point where two lines intersect, the object path and one of the four reference lines that form the rectangle.
• A chart is...

Read more about this Excel article...

 

[clamnets]

Maybe its a version discrepancy issue but I get "Compile error: User-defined type not defined" referencing line 128, 'Sub PPoint()'. I do still get output which defaults to starting at 16,3 and θ=20 somehow.

 

[clamnets]

Maybe its a version discrepancy issue but I get "Compile error: User-defined type not defined" referencing line 128, 'Sub PPoint()'. I do still get output which defaults to starting at 16,3 and θ=20 somehow.

I'm realizing that the only part not working is where it is trying to create a PowerPoint. Is there some sort of permission that needs to be changed? Or do I need to do some additional setup?

 

[Worf]

At Excel VBA, add a reference to the Microsoft Power Point library.

 

[Worf]

https://www.wallstreetmojo.com/vba-powerpoint/