Forms in Excel?

[Novexx]

Is it possible using the VB editor in Excel to create a form with some variable text fields, which will open with a workbook for the varibles to be entered, & can then be made to populate specified cells with the info from the variable fields in the form?

 

[PHV]

When in the VBE menu Insert -> UserForm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,

Also check out Data > Form...



Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]