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

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

Bob,

That works. (embarrassed)

Then how do I get it to work the other way. Change it in
the form and have it update the cell.


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



.

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



.