Textbox negative values not showing correctly

And the password is?

Fluff13,

Genuinely stumped on this, because the attachment was "unlocked", so no idea how it had a password when you opened it?

Can you try and open it again?

Ochimus

The VBA project is definitely password protected.
Although that may now be irrelevant, as you got some solutions.

shg,

Appreciate the prompt response, but ".forecolor" throws a Compile error "invalid or unqualified reference"?

Having remembered that "RGB" returns a Long, so tried declaring "forecolor" as Long, but that generated the message that "Member already exists in an Object Module from which this Object Module derives"

Never come across before?

Ochimus

Fluff,

Apologies, but when I attached the file at 09:37 I must have used the "Protected" version . When I amended the entry three minutes later, I attached the "unlocked" version, which the others obviously found when they clicked on to the question.

Ochimus

Gentlemen,

Turning into "One step forward, Two back".

Tried the approaches on the "Stage 2" document which has an extra element.
Losses appear correctly in brackets with red font, but ROI is not working, as explained on the front sheet of the attached.
Can't see where the logic is falling over, but confident someone will.

Please Login or Register  to view this content.

Ochimus