Capturing data from a form

[Brent]

Please help.

Once the fields within a form have been populated, how do I capture the
information for subsequent processing? Related to the form, is there a
programmable function to "Clear" all unprotected cells?

 

[JLGWhiz]

If a list box:

Range("A1") = ListBox1.Value puts the selected ListBox item in
Range A1 of the ActiveSheet. Put the code in the click event of the
control. See ListBox in VBA help. Also see Click Event in VBA help.
There is more there about Selected for multicolumn lists, etc.