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).

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).

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:


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