mortgageman
Well-known Member
- Joined
- Jun 30, 2005
- Messages
- 2,015
Can textboxes display fractions?
Gene, "The Mortgage Man", Klein
Gene, "The Mortgage Man", Klein
Gene
It depends what you mean really.
You could use a textbox to type in something like 1/2 then use code to interpret that as 0.5.
Gene
Why are you using textboxes if there's going to be no user input? Why not use labels?
Also why not load the fractions from a worksheet using the Text property of a cell. That returns the value in the cell as it's formatted on the sheet, though I'm not 100% sure how it would work with the Fraction format.
I'll have a look into it and post back.
Label1.Caption = Range("A1").Text
I'm not 100% sure how you'll be able to use this in the rest of the code.
You'll somehow need to change it back to a value, if you want to compare it to other values.