Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format - KING OF EXCEL

Tuesday, January 21, 2020

Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format

Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format

Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format

Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format

Text Box Properties 


In Excel VBA tutorial 4 we learned how to add different tools to the user form. In today's tutorials, we will learn about the properties of text boxes. We will learn about different formats of text boxes.
About User Form Properties In Tutorial 3, we saw some important points. In the same way every tool has its properties. Some tabs are more or less according to the tool.

Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format

1. Name - Any name can be given to the text box.
2. Text box Size - Option of drag and drop with the mouse is better to increase the size or more.
3. Control Tip Text - When the application is run, you have to type the text in the control tip text to show a text tip as soon as the mouse cursor is moved over the text box.

Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format


4. Enable - Many times the project has to show the text in the text box, but to ban it from editing, Select False Option in the option of enable, no user can edit the text of the text box.
5. Visible - To hide the text box, the text box will be hidden as soon as it is false in front of the Visible option.
6Text - To show any text by default in the text box, you can type the words type in front of the text option.
7. With the option of Text Align, Back Color, Border Color, you can change the design of the text box.
8. Password Character - Type one of the special characters in the password char to show the text * or # or @ of the text box as such.
For example - When typing a text box password, all we need to do is to show * star *, type password Char  *  .

Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format

How to change the text box format?

1. Text box currency format

To change the text box Value to currency format, double click on the text box or right click to view code.

Private Sub TextBox1_Change() 
End Sub

The text box name and change will appear. That means, while making any change in the text box, we can give the command in it. You can see multiple options in the drop down option by clicking above the change option above. We will be able to make any changes according to the behavior of the text box. We have to type the code of the format in the line below Private Sub TextBox1_Change ().
Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format

Private Sub TextBox1_Change()
Me.TextBox1.Text = Format(Me.TextBox1, "####,##")
End Sub

Now run the project by pressing F5. And type any number in the text box. The value will be converted to currency format only while typing.

If you need a decimal number in the currency format, then click on the text Behavior After Update

Me.TextBox1.Text = Format (Me.TextBox1, "####, ##. 00") Apply this code.


Private Sub TextBox1_AfterUpdate()
Me.TextBox1.Text = Format(Me.TextBox1, "####,##")
End Sub

2. Text Box Date Format -

To convert a value to a date format, double-click on the text box and select Text Behavior After Update. And apply the format code below.


Private Sub TextBox2_AfterUpdate ()
Me.TextBox2.Text = Format (Me.TextBox2, "dd / mm / yyyy")
End Sub

Excel VBA Tutorial 5 - Text Box Properties, Text Box Currency Format and Date Format


You can use dashes or slashes in the date format or you can use a different format.

dd-mm-yyyy

dd/mmm/yyyy
mmm/dd/yyyy


Similarly, you can apply any format in the text box.
Me. TextBox .Text = Format (TextBox, "Format")

These were some important text box formats, which are always used in data entry user form. Learn about combo box behavior in Next Tutorial.
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment