UserForms

Here, you can,

Hide the current UserForm and display another one (Watch the Video).

Transfer data from a USERFORM to an Invoice template Sheet (Watch the Video).

Convert the result of a TextBox to the “Integer” format (e.g., 5) (Watch the Video).

Convert the result of a TextBox to the “Decimal Number” format (e.g., 1.20) (Watch the Video).

Convert the result of a TextBox to the “Currency” format (e.g., $4.50) (Watch the Video).

Convert the result of a TextBox to the “Date” format (e.g., 11.12.1998) (Watch the Video).

Convert the result of a TextBox to the “Number + Text” format (e.g., 12 Pounds) (Watch the Video).

Convert the result of a TextBox to the “Percentage” format (e.g., 10%) (Watch the Video).

Convert the TEXT from a Textbox to UPPERCASE format (e.g., HELLO) (Watch the Video).

Convert Each Word in a Textbox to “First Letter Uppercase” Format (e.g., Be My Girl) (Watch the Video).

Convert the result of a TextBox to “EMAIL” format (e.g., my@mail.com) (Watch the Video).

Change the background color of the TextBox (e.g., Red >= 100 > Blue) (Watch the Video).

Change the font color of the TextBox (e.g., Red >= 100 > Blue) (Watch the Video).

Modify the color of your UserForm using ColorDialog (Watch the Video).

In a TextBox, display the Number of NON-EMPTY ROWS in a Column (Watch the Video)

In a TextBox, display the Number of UNIQUE VALUES in a Column (Watch the Video)

In a TextBox, display the Number of NON-EMPTY ROWS and UNIQUE VALUES in a Column (Watch the Video)

Simply insert the requested value in the box, click the “Get Code” button, and voila, the code appears in the square at the bottom of the page…copy it and paste it into your UserForm…That’s it 🙂

Hide the current UserForm and display another one

Inter the Name of the Other UserForm to Display:

Transfer data from a USERFORM to an Invoice template Sheet



Insert ( IN ORDER) the Names of the Objects of the UserForm :






Insert ( IN THE SAME ORDER) the Names OF the Destination Cells:






Convert the result of a TextBox to the “Integer” format (e.g., 5)

Insert the Name of the TextBox in question:

Convert the result of a TextBox to the “Decimal Number” format (e.g., 1.20)

Insert the Name of the TextBox in question:

Convert the result of a TextBox to the “Currency” format (e.g., $4.50)

Insert the Name of the TextBox in question:

Convert the result of a TextBox to the “Date” format (e.g., 11.12.1998)

Insert the Name of the TextBox in question:

Convert the result of a TextBox to the “Number + Text” format (e.g., 12 Pounds)

Insert the Name of the TextBox in question:

Convert the result of a TextBox to the “Percentage” format (e.g., 10%)

Insert the Name of the TextBox in question:

Convert the TEXT from a Textbox to UPPERCASE format

Insert the NAME of the relevant TextBox:

Convert Each Word in a Textbox to “First Letter Uppercase” Format

Insert the NAME of the relevant TextBox:

Convert the result of a TextBox to “EMAIL” format (e.g., my@mail.com)

Insert the NAME of the relevant TextBox:

Change the background color of the TextBox (e.g., Red >= 100 > Blue)

Insert the Name of the TextBox in question:

Change the font color of the TextBox (e.g., Red >= 100 > Blue)

Insert the Name of the TextBox in question:

Modify the color of your UserForm using ColorDialog
In a TextBox, display the Number of NON-EMPTY ROWS in a Column





Dans un TextBox, afficher le Nombre de VALEURS Uniques d’une Colonne





Dans un TextBox, afficher le Nombre des lignes non vides et Valeurs Uniques d’une Colonne