User Form Deluxe 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 Data Form, shown in Figure 15-18. You'll recall this is the dialog box that appears when you choose Data ^ Form.

1 of 144

Quarter; |qi

New

Winery: iBeaulieu

Delete

Appellation: 1 Cabernet Sauvignon

Restore

Region; 1 North

Find Prev

Cost Per Case: fl65 Cases Sold: |450

Find Next

Sales: $74,250

-

Criteria Close

Figure 15-18: Excel's Data Form.

Figure 15-18: Excel's Data Form.

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

Excel Vba Forms
Figure 15-19: The author's Enhanced Data Form.
0 0

Post a comment