VBA Help: Perform Calculations Between Cells with VBA

**Jambo11** · 12-13-2011, 03:21 AM

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)))

**Ryan Murtagh** · 12-13-2011, 03:31 AM

Hi Jambo11,

Can you upload a sample document containing dummy data and/or your current solution? Also, your thread title is fairly vague. Please consider revising, pursuant to the forum's rules governing the naming of threads.

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

**wamp** · 12-13-2011, 03:40 AM

this is untested, but I assume you want something like this... ?

Please Login or Register  to view this content.

**snb** · 12-13-2011, 04:01 AM

or

Please Login or Register  to view this content.

**wamp** · 12-13-2011, 04:12 AM

no but, see...
your code is simply too clean snb :-p

(didn't know you could keep it that simple :-) *thumbsup*

**Jambo11** · 12-21-2011, 08:43 AM

I really appreciate the help from you two.

I'm finding that either of those macros will work wonders in helping me achieve my goal, but I'm having trouble figuring out how to get it to loop. No doubt, a "Do" loop would be a good approach, but I can't figure the right syntax, or the right "Do" loop to use.