You can use the code approach, with checks
before it, that I suggested.

HTH,
Merjet
"Cody Dawg" wrote in message
...
Thanks,

but the problem with this is that as you input data into the form, it goes
straight to the worksheet and can't be undone. I should have stated this
earlier, but one of the purposes of this form is to give the user a
chance
to review the data entered before accepting it and sending it to the
sheet.
So the form acts as a kind of "data buffer".

Any suggestions will be appreciated.

"merjet" wrote in message
. net...
I'm able to put together the form and command buttons, etc., but
cannot
figure out the way to have the numbers in the form go to specific
cells
on
the active worksheet.

If you don't mind the contents of the cells appearing in the TextBoxes
when the UserForm is shown, you can use the TextBox's ControlSource
property, e.g. Sheet1!A1. Or you can put code behind the "accept"
CommandButton, e.g.:
Sheets("Sheet1").Range("A1") = TextBox1.Text 'or
Sheets("Sheet1").Range("A1") = TextBox1.Text 'or
ActiveSheet.Range("A1") = TextBox1 'or
ActiveSheet.Range("A1") = TextBox1.Text

HTH,
Merjet