copy only visible text boxes to clipboard from user form

[brewsi]

hi all

i have been stuck on this for a while now. i have created a command button that copies a string to clip board. this strings is made up of text boxes on a user form. the text boxes are filled in by the user but depending on the users input some remain hidden. when i copy to clip board the hidden text boxes leave blank gaps . is there any way to get these removed so when pasted the hidden text boxes dont leave a gap. Heres my code. thank you so much in advance for your help

Please Login or Register  to view this content.

[Tinbendr]

This should work. You'll have to make a Case for each control, adding the additional line feeds and spaces as required.

Please Login or Register  to view this content.

[brewsi]

hi Tinbendr

Thanks for the quick response. Unforunately that code seems to just take the A0 box and repeatedly copies it and no others.

Any Ideas?

[Tinbendr]

Hmmm, yes, you're right.

Perhaps

Please Login or Register  to view this content.

[brewsi]

hi Tinbendr

you'll have to forgive me here. i Am quite new to VBA. i have altered the code as you suggested and it is still copying hidden text boxes

heres the code i am using

Please Login or Register  to view this content.

thanks for your help

[Tinbendr]

Ha! No. Like this

Please Login or Register  to view this content.

You have to fill the rest of the Case Statements for each Textbox since you seem to have different spaces and line feeds between different textboxes.

If you have the same pattern, then they can go on the the Case line separated by a comma.

I create an array with all the names of the controls. I, then, iterate through the list, testing for Visible in each control name.

If you still can't get it, upload a sample sheet with the userform.