Hi

I have created a survey where people have entered answers into a text box.
I am wondering whether I can convert their answers into cells to make them
easier to collate. Anyone know if it is posible??

Range("A1").Value = Userform1.TextBox1.value

HTH
--
AP

"Linda B" <Linda a écrit dans le message de
news: ...
Hi

I have created a survey where people have entered answers into a text box.
I am wondering whether I can convert their answers into cells to make them
easier to collate. Anyone know if it is posible??

Thanks Ardus.

Sorry to be a doofus but I take it that this is a VBA string. No experience
in this. Do I open VBA editor, click on sheet 1 to display the code and put
in your string? Is the "A1" the destination cell for the output?
Do I need to replace Userform1 with the name of the worksheet on which the
text box appears?

I really appreciate you replying so quickly. Thank-you.

Linda

"Ardus Petus" wrote:

Range("A1").Value = Userform1.TextBox1.value

HTH
--
AP

"Linda B" <Linda a écrit dans le message de
news: ...
Hi

I have created a survey where people have entered answers into a text box.
I am wondering whether I can convert their answers into cells to make them
easier to collate. Anyone know if it is posible??