(Solve) How to add second loop in VBA coding

**SubwAy** · 10-31-2011, 09:31 AM

Hi guys,

I have been seeking help on this forum for quite a few days now and I've received some great support from fantastic users. So before anything, thanks all of you for your help!

Andrew developed this coding for me in a previous post and I would like to add one change:

Please Login or Register  to view this content.

I would like to modify one small thing in this script though: apart from everything that the script is already doing (and it's doi ng it really well), I would like the cells S4 in the three graph spreadsheets to also display the value entered in G20. At the moment, whatever is entered in S4 appears in G20 but not the other way around.

Is this possible without any major modification? I am just worried I am not going to be able to implement the change if it's something drastic.

Thanks for your time guys.

**royUK** · 10-31-2011, 09:46 AM

Please use Code Tags not Quote tags

**SubwAy** · 10-31-2011, 09:52 AM

Sorry, fixed it :-)

**SubwAy** · 10-31-2011, 07:17 PM

Hi guys,

I was wondering if by any chance any of you would be able to help me with this problem... I tried to understand and changing the coding myself, I wasn't really successful :-)

Thanks for your time and help!

**SubwAy** · 11-01-2011, 06:21 AM

I've tried a few different combinations without success.

Can it actually be controlled through the same macro or would it have to be something completely different?

Thanks for your time guys

**foxguy** · 11-03-2011, 04:05 PM

I don't understand what you want.
Right now the code is doing this:

Please Login or Register  to view this content.

I don't understand when you say

I would like the cells S4 in the three graph spreadsheets to also display the value entered in G20. At the moment, whatever is entered in S4 appears in G20 but not the other way around.

I'm guessing that you want each of the Graph sheets to show 2 values:
1) The value of an S4 that you manually entered on one of the sheets.
2) The value of G20 on the individual Graph sheets (not the value in G20 of the DailyPlot sheet - because it just contains a copy of the S4 that you manually entered).

Assuming that's right change the line

Please Login or Register  to view this content.

If that's not what you want, then you will have to give me an example of what you do want. And don't just use the Address of the cells, use the sheetname and the cell address.

**SubwAy** · 11-03-2011, 09:55 PM

Hi foxguy,

I have recreated a mock file with the exact same sheet names and number as my model.

What I'd like to do is fairly simple:

. Whatever I enter in G5 (Sheet2) from the drop down list appears in S4 on Sheet6, 7 and 9.
. Whatever I enter in S4 (Sheet 6) from the drop down list appears in G5 (Sheet 2) and S4 in Sheet 7 and 9
. Whatever I enter in S4 (Sheet 7) from the drop down list appears in G5 (Sheet 2) and S4 in Sheet 6 and 9
. Whatever I enter in S4 (Sheet 9) from the drop down list appears in G5 (Sheet 2) and S4 in Sheet 6 and 7

I hope this clarifies my previous confusing explanation.

Thanks again for your help!