VBA If statement to copy certian text boxes depending on value

[ciresuark]

I have 5 text boxes that could collect data. Some of the text boxes may not have data in them and I wouldn't want them copied. I currently have:

Please Login or Register  to view this content.

So if txtName, txtUser and txtForm have text but txtCoName and txtPhone do not only those text boxes would be copied. Is there an if statement to only use the clipboard for the textboxes that contain text?

Thanks for your help.

[JBeaucaire]

Something like this:

Please Login or Register  to view this content.

[Trebor76]

Untested but try this:

Please Login or Register  to view this content.

HTH

Robert

[ciresuark]

Thank you JBeaucaire. This will only copy txtName, and no other fields. If txtName and txtFrom are filled out and the other three are not, I would like only those two to be copied to the clipboard.

[ciresuark]

Trebor76 I tried your code and receive a Run-time error '-214702489 (80070057)': Could not find the specified object error. When I debug it highlights:

Please Login or Register  to view this content.

Thanks

[JBeaucaire]

This will only copy txtName, and no other fields.

What makes you think that? Read it through again. It tests each of your 4 fields and adds them to the clipboard if they are not blank.

[Trebor76]

Trebor76 I tried your code and receive a Run-time error '-214702489 (80070057)': Could not find the specified object error. When I debug it highlights:

Please attach a copy of your workbook devoid of sensitive information so we can actually see what's happening. Thanks.

[ciresuark]

JBeaucaire your code did work. I changed the names of the text boxes after I posted this and didn't change them in the code you provided. My bad.

Thanks for your help!!!

[Trebor76]

I changed the names of the text boxes after I posted this and didn't change them in the code you provided

I dare say that was probably the issue with my code too. Glad you got it sorted in the end.