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]

If you step through LoadValues_NIST manually and hover over Typer, at no point does it hold a value !
But why are you trying to create Typer using a function ?
Could it not simply be created within the sub itself ?

 

[8700Rakf]

Typer is a sort of scaling, where it multiplies the existing predefined limits with 1(Normal), 5(Post Scale) and 20(Scale). This was the only way i could figure out, a way for it to scale every different Version types, and class types.

I might be wrong in how it is done though, but as i lack experience, this was what i came up with.

But why doesnt it hold a value? weird.

 

[8700Rakf]

Bump

 

[8700Rakf]

So if i add i button, that activates Version dropdown, when pushed on it. everything works fine, and becomes as intended, its just not dynamically changing as i want, when changing something in the dropdowns.