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

M

Mark Stephens

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
 
R

Rick Rothstein

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top