VBA Userform, How do I Successfully Change Textbox Number Format Value

Question

I have a UF calculator I'm using to provide a length measurement. I have one textbox returning the result in decimal inches, but I also have a secondary that I would like to create an "easy read" for use with a standard US measuring tape.

The number format works well in a worksheet cell, but not in this textbox. Is there a better way to go about this?

My value is 106.59375; as a worksheet function/format, the result is 106 19/32. With VBA, I'm given 1/07. I've played around with it, and it seems to be rounding value to 107, then applying the format.

UFChordCalc.TBResult.Value = Round(chordLength, 3)
With UFChordCalc.TBER
    .Value = Application.WorksheetFunction.MRound(TBResult, 1 / 32)
    .Value = Format(.Value, "# ##/##")
End With

Do you have a dot in the number - this is a decimal point ? Try 10659375 — user19618751
– user19618751, Commented Oct 27, 2022 at 13:34

IvanSTV · Accepted Answer · 2022-10-27 13:41:31Z

1

I'd put the value in 2 string variables - first -before the decimal mark, second - after decimal mark in format "1/32" and then stick together with "&"

answered Oct 27, 2022 at 13:41

IvanSTV

3642 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Userform, How do I Successfully Change Textbox Number Format Value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related