Forms

Jonathan Lee

New Member
Joined
Feb 22, 2015
Messages
11
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,531
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
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

New Member
Joined
Feb 22, 2015
Messages
11
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?
 

Forum statistics

Threads
1,085,294
Messages
5,382,755
Members
401,804
Latest member
RB85

Some videos you may like

This Week's Hot Topics

Top