I need users to be able to put their cursor on a line in a spreadsheet, then
click a macro button, and have a form pop up, which will have certain cells
from that line that they're on populate into various fields.

Is there a way to get this done? I know there are forms, and I know there
are the types of fields that reference a particular cell. Is there anyone
that can give me the quick advice on which types of fields will accomplish
this? So the ideal is something that populates the fields, lets the user
change values, and then has some sort of OK or Cancel button to get out and
back to the regular sheet.

Thx.
--
Boris