Select Case not working properly?

[jayherring86]

Hello everyone, i'm not having a very good day of it today.

Take a look at the image i have attached, can anyone tell me why the macro has run to the second Case, and not realised that the first one is true? This happens whether I have the first case as "Case Action = 0.283..." or "Case progress.width"

FYI, if i press F8 again it will run the Online_FeedbackALL sub as though the progress.width was sized between those two values (it isn't, as the immediate window shows)

Capture.JPG

[Andy Pope]

more like

Please Login or Register  to view this content.

[jayherring86]

FANTASTIC! in 2 words and a bit of code you have made Select Case clearer than the microsoft help pages could ever do!

Thank you so much. Changes have been made and the rest of my day looks brighter already

[jayherring86]

except one minor thing. As a variant, the action variable did not get recognised as being the same when i put "action = progress.width"
setting it as a long seems to have fixed this.

thanks again