Basic user form question - hjow to write to a text field
 

Hi,

I have a user form which i am populating with data from various cells in my
database located in a sheets row and columns.

I need to be able to not only view the contents of the cells in the text
boxes on the user form but write to them as well and then relect the updated
combination of the existing text and the new text with the new text on line
one and the old text relegated to line 2.

At the moment (andI can't change it hence my post), I cannot select the end
of the existing text line only write over it which is not what I want. I was
expecting to find a read and write property for a text box but in its
absence I am at a bit of a loss. Sorry I know it's basic but can someone
help?

Thanks Mark

Basic user form question - hjow to write to a text field
 

Your question, nor the restrictions you are working under, is not entirely
clear to me; however, I make a stab at an answer for you. The TextBox on a
UserForm has a ControlSource property which you can use to link the TextBox
to a particular cell. So, if you set the ControlSource property of one of
your TextBoxes to C6, then when you ran your UserForm, that TextBox would
contain the contents of cell C6 and, if you change the value in the TextBox,
the value in C6 will change when you exit the TextBox or close the UserForm.
If this did not answer your question, then you will need to give us more
detail as to what you want and the restrictions you are working under.

--
Rick (MVP - Excel)


"Mark Stephens" wrote in message
...
Hi,

I have a user form which i am populating with data from various cells in
my database located in a sheets row and columns.

I need to be able to not only view the contents of the cells in the text
boxes on the user form but write to them as well and then relect the
updated combination of the existing text and the new text with the new
text on line one and the old text relegated to line 2.

At the moment (andI can't change it hence my post), I cannot select the
end of the existing text line only write over it which is not what I want.
I was expecting to find a read and write property for a text box but in
its absence I am at a bit of a loss. Sorry I know it's basic but can
someone help?

Thanks Mark