Userform Textboxes

[JeremySun]

Is there a way to copy all the data in textboxes on a userform? Basically I have 24 textboxes and I want to copy all the textboxes with data and place on a word doc.

 

[bensonsearch]

Hi, yes.

if you are testing data then something like

dim words as string
 
words = ""
 
if textbox1.text <> "" then
words = words + textbox1.text
 
elseif textbox2.text <> "" then
words = words + textbox2.text
 
elseif textbox3.text <> "" then
words = words + textbox3.text
 
elseif textbox4.text <> "" then
words = words + textbox4.text
 
elseif textbox5.text <> "" then
words = words + textbox5.text

etc etc all the way down to 24. then words would equal the sum of the textboxs. just remeber if you want a space at the end to put

words = words + textbox5.text & " "

 

[JeremySun]

Thank you . Do you know of a way to copy all textbox values?

 

[bensonsearch]

the above should copy them all. if not try

words = textbox1.text & textbox2.text & textbox3.text & textbox4.text

etc etc up to 24 again