Forms

[Jonathan Lee]

Hi all,

Need your help here.

I know how to create a form. Control T and such.

But how can I customize the form. Make it bigger and color it.

The form would be use to input data. Only completed data will be saved. But before saving, there will be a requirement to enter the next set of data. How can this be done?

Thanks in advance.

 

[RoryA]

You can't customise the built in data form. You'll need to open the VB Editor (Alt+f11) then insert a userform and add whatever controls and code you require.

 

[Jonathan Lee]

You can't customise the built in data form. You'll need to open the VB Editor (Alt+f11) then insert a userform and add whatever controls and code you require.

Thanks.

Is there a tutorial for creating the form in VB Editor?

 

[RoryA]

Probably several. This might be useful: https://excelmacromastery.com/vba-user-forms-1/