Add default value to userform text box

[nparsons75]

Hi,

I need to add a default value to a field in a userform.

For example, when a userform is opened and also when i click a submit button to enter the data, the clear form will show a default value in one particular field.

Basically I want one field named field1 to always have a default numerical value inserted. This can be cleared by the user but initially it should always show in the field.

Is this possible?

Thank you.

 

[Kenneth Hobson]

In the Properties window for that control, set the Value property. Press F4 to view that window or in VBE, select that option in the View menu. If you want a dynamic value, then set Textbox1.value = "whatever" in the Userform's Initialize event.

 

[nparsons75]

Hi Kenneth,

How do you mean dynamic. I simply want the field to always show the value '20'

I need the value to appear in the box each time the userfom opens and each time data is submitted and the form is ready to add new data.

Thanks for the help.

 

[Kenneth Hobson]

Always implies static. Dynamic implies being able to change based on various criterion.

Sounds like you are new Userforms. There are many tutorials that explain the Properties window for "static" settings.
https://www.youtube.com/watch?v=-XsNDxlE04o
https://msdn.microsoft.com/en-us/library/office/aa192538(v=office.11).aspx