Can I out the contents of a text box into a cell?
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?? |
Can I out the contents of a text box into a cell?
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?? |
Can I out the contents of a text box into a cell?
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?? |
All times are GMT +1. The time now is 10:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com