mpfanalytics
New Member
- Joined
- Aug 31, 2019
- Messages
- 1
Hi all, first post here.
I've been learning VBA, and I've found the best way for me is to jump into exercises I've never done before. I recently came across a problem and decided to take a shot at it. I'm trying to use VBA to solve for the equation A = (B/C)^D, where any one variable A, B, C, or D is missing, and the others are constants pulled from cells. Ideally I'd like to create a msg box where you can input a value for each variable and it'll solve for the missing variable, but baby steps lol. Any help would be appreciated! I have attached images below of what I've done so far.
[/IMG]
[/IMG]
I've been learning VBA, and I've found the best way for me is to jump into exercises I've never done before. I recently came across a problem and decided to take a shot at it. I'm trying to use VBA to solve for the equation A = (B/C)^D, where any one variable A, B, C, or D is missing, and the others are constants pulled from cells. Ideally I'd like to create a msg box where you can input a value for each variable and it'll solve for the missing variable, but baby steps lol. Any help would be appreciated! I have attached images below of what I've done so far.
![J4DFspV.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttps%3A%2F%2Fi.imgur.com%2FJ4DFspV.png&hash=cf0737735583f396963ee8c10e24419f)
![fSIQPoW.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttps%3A%2F%2Fi.imgur.com%2FfSIQPoW.png&hash=b7c8d5561c238fd0dd2e52080992c3c8)