Programming Excel with VBA and .NET

Design Your Own Forms

If the built-in forms don’t meet your needs or if your task is more complex than the preceding data-entry sample, you can use the Visual Basic Forms Designer to create your own custom forms in Excel.

To create a custom dialog box using the Forms Designer:

1. Start the Visual Basic Editor and choose Insert → User Form. Visual Basic displays a new form and the Control Toolbox.

2. Drag controls from the Toolbox onto the form as shown in Figure 20-7.

3. Set the properties in the Properties window (Figure 20-8) as you position the controls on the form. Table 20-3 lists the controls and property settings used for the Stock History sample.

Figure 20-7. Drag controls from the Toolbox onto the user form

Figure 20-8. Set the controls’ properties as you place them on the form

Table 20-3. Controls and property settings for the Stock History form

Control	Property	Set to
User form	Name	frmStockHistory
	Caption	Stock History
Label	Caption	Symbol
Label	Caption	#Days
Label	Caption	Preview
TextBox	Name	txtSymbol
	Caption	^IXIC
	ControlTipText	Stock symbol or index
TextBox	Name	txtDays
	Caption	100
	ControlTipText	Value from 1 to 300
SpinButton	Name	spnDays
	Delay	20
	Max	300
	Min	1
	Value	100
Image	Name	imgChart
	Height	150
	Width	180
CommandButton ...