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.
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,098,970
Messages
5,465,737
Members
406,448
Latest member
IrishDMan

This Week's Hot Topics

Top