VBA I want the sheet to calculate I1 for me when certain conditions are met.

**g123456789** · 06-13-2019, 12:00 PM

I have not taken a VBA class in a very long time.. I would greatlyyyyy appreciate it someone could please explain this or write this simple macro for me????

In the attached worksheet i have a sheet that has a input value LREQ (cell I1). I normally enter a value in this cell I1 (increments of 0.1) until cell B5 is just under cell D5 and same with B6 and D6 (until one of the conditions are met first)...B5 and B6 can not be greater than D5 and D6.

I want the sheet to calculate I1 for me until these conditions are met.

G1 is the only value that the user(myself) would have to enter (the rest of the numbers are already calculated or are constants).

Maybe this doesn't need a macro?

Thoughts? ANY help would be greatly appreciated.

**AliGW** · 06-13-2019, 12:04 PM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)