I'm trying to figure out how to perform math functions with VBA. My ultimate goal is to create a 3-cell circular reference, with data being able to be entered into any of them.
It occurred to me that one way of facilitating such a feat would be through the use of textboxes, or by simply referring to the applicable cells in VBA.
The following are the calculations that I'm trying to perforn in VBA:
E:E = B:B / C:C
F:F = E:E + G:G
G:G = F:F - (C:C / D:D)
H:H = (F:F - (C:C / D:D)) / (C:C / D:D)
I:I = D2 * (F:F - (C:C / D:D))
J:J = D:D * (C:C * (F:F - (B:B / C:C)))
Bookmarks