Populating txtboxes
Never mind.
Just update the the txtbox. I do not even need code for
that!
Wow.. way cool. I have just fallen in love with forms.
(really embarassed)
Dave
-----Original Message-----
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
.
|