VBA Coding: I have data that is being output into TextBoxes on a UserForm. The d

Question

VBA Coding:                                                                                                                                                                                                                                                                                         I have data that is being output into TextBoxes on a UserForm. The data being output is from a caluclation, but I want it to only be three digits after the decimal.                                                                                                                                                                                                                                                                                           tl;dr How to limit the characters shown in a TextBox

Explanation / Answer

How to limit the characters shown in a TextBox

You can use TextBox.MaxLength Property (Ref: https://msdn.microsoft.com/en-us/library/system.windows.controls.textbox.maxlength(v=vs.110).aspx)

Or you can use

With this you will always have three digit after decimal

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.