Not running as hoped

[8700Rakf]

Hello

I have some code that is on paper( I think ), should run fine. When i use debug, I can see that all is going well and as expected.

But when i do it outside the debugger, and on my sheet, it doesnt run as expected.


I have quiet a large code snap, and would rather attach the excel file, but i cant see a way to do it here?

 

[Michael M]

You can't attach files in this forum.
Have a look at these options for uploading to this forum
https://www.mrexcel.com/forum/about-board/508133-attachments.html

OR

you can upload your file to Dropbox, then post the link back here and someone may be able to help you out.

 

[8700Rakf]

https://www.dropbox.com/s/is4gbia1g9z9iud/NytScale.xlsm?dl=0

Thats is the link

What I am trying to do is, that i want it to change dynamically, depending on the choices you make. Not sure if its a good way i've done it, but it the only way i could figure it.

hope for some nice advice

 

[8700Rakf]

Bump

 

[Michael M]

So what is it not doing, or doing incorrectly ??
Are you checking the code line by line using F8.....and looking at the results as you go ?

 

[8700Rakf]

Yes I am using the Debugger. So when I am running it without it, the area which is supposed to change, just keeps showing 0.
When using debugger, inside the code, it does what it is supposed to do.

 

[Michael M]

I've tried changing a couple of the dropdowns....but it always returns 0.....even if I run it manually ??
Might have to get another poster to take a look....it's a bit hard to follow !

 

[8700Rakf]

you sure it returns 0?

I see, sorry for the trouble, but thanks for having a look at it though! And yeah there is quiet a lot to look at, so it a bit complicated.

 

[Michael M]

I put a breakpoint in the version dropdown code

Private Sub VersionBox_Change()

Call SelectionClass
Call SelectionScale

Call LoadValues_OLD_EU
Call LoadValues_NEW_EU_Multi
Call LoadValues_NEW_EU
Call LoadValues_NMIA
Call LoadValues_NIST

End Sub

Then made a couple of version choices....that then allowed me to step through the code....and every time it came back with....0 > m > 0 on A14 to A16.
I wondered though if it has something to do with your using merged cells...which can be a nightmare for VBA ??

 

[8700Rakf]

Maybe, I am not sure. What kind of problems does merge cells cause?

Actually, everything was running smootly until I added the LoadValues_NIST sub, after that thing didnt work out, correctly. So I thought, that I had added too much, for excel to function correctly.