Just link the ControlSourec property of the text box to the cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dave R." wrote in message
...
I have a form that contains multiple textboxes.
Lets say the data from txtbox1 will populate cell a2
And txtbox2 will populate cell g10

But when the form comes up, I first want each txtbox to
retrieve what is currently in their corresponding cells
as a prompt, if the user likes it, they simply enter on
past and it stays the same. Or they can change it and it
updates the cells accordingly.

I currently have this running with Inputboxes, but would
really like to try it with a Form.

Your help is greatly appreciated.

Dave