An Enhanced Data Form

Next is one of the more complex UserForms that you'll encounter. I designed it as a replacement for Excel's built-in Data Form, which is shown in Figure 15-26.

Figure 15-26: Excel's Data Form.

Note Displaying Excel's Data Form is not easy in Excel 2007. You need to use the Excel Options dialog box, click the Customization tab, and add the Form command from the Commands Not in the Ribbon group. Then, the Form command will appear on your Quick Access Toolbar.

Like Excel's Data Form, my Enhanced Data Form works with a list in a worksheet. But as you can see in Figure 15-27, it has a dramatically different appearance and offers several advantages.

u

tm *

JMW:-

4 SI ifil

a ».If

■in. ii

1 ill

1

H <i _a£ï3,iapm

il«.™

t J : cu

Irph^,

»».if

»HU

h

MMWi

JH

■A

iliiLid LMa Pom

u

■Vü "i Jt

] 111

w ■

a» 1 w

'i-il

iU.

■■

I'WW"

- 1

Hi

•W

'ww

- :

'—II

1»-■

---

" aiflW

IMtoP JtftlUU

ÇT-MJ

'L. IT

u

H-* »1 A-t V

HfcW IJMWi lillfW

'en Cvn

rl^JI

fvl

1MH

u-*ä «a

-raj

■ML.« J ÜLF flB

»■»■■i

Ll'îW

"4H

IUI

ui'.j.. .'. y

" it

■U4

lui

H

Ij->14 3'J^'iA}1

■ ■wir

lut

S' . p.iiTWÇB

■tir

'KU |«t

!•■-■« kVMP

—1

Jj

M-H

•mJJT

11ll

u.

lil'J

i/1

jrmt+r

1 W

JIJJ.

IfeUi,

1UÎ

■'ÎISW 1,1 "SWT

-

na.ir

iMJI

1-131 11V 1

-i ■Tr-.-'i

ÏW.f«

î id w

(»■■Mt-

mil

isHI4W

a j Liu»

■¡MM,

'•M

tui

-- ML

Figure 15-27: My Enhanced Data Form.

Figure 15-27: My Enhanced Data Form.

0 0

Post a comment