hi guys,

hope you can help. its been beating me for weeks

i have a user form where people fill in data into text boxes. some text boxes remain hidden if the user does not need to fill in the requested field. but when the command button is submitted all text boxes hidden or otherwise are copied to clip board.

Does any one know the vba in order for only visible text boxes to be copied to clip board. i was thisnking of some sort of if statement around the vba to copy to clip board but nothing i use works.

I really hope someone can help

Thanks in advance