copy to clip board only visible text boxes from user form

[brewsi]

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

[Norie]

Can you post your current code?

[brewsi]

at the moment i am using this to copy all text boxes to the clip board

Private Sub CommandButton1_Click()


Dim DataObj As New MSForms.DataObject
Dim STR1 As String

STR1 = A0 + vbCrLf + A1 + vbCrLf + A2 + vbCrLf + A3 + vbCrLf + A4 + vbCrLf + A5 + vbCrLf + A6 + vbCrLf + A7 + vbCrLf + A8 + vbCrLf + A9 + vbCrLf + A10 + A11 + vbCrLf + A12 + vbCrLf + A13 + vbCrLf + A14 + vbCrLf + A15 + vbCrLf + A16 + vbCrLf + A17 + vbCrLf + A18 + vbCrLf + A19 + vbCrLf + A20 + vbCrLf + A21 + vbCrLf + A22 + vbCrLf + A23 + vbCrLf + A24 + vbCrLf + A25 + vbCrLf + A26 + vbCrLf + A26 + vbCrLf + A28 + vbCrLf + A29 + vbCrLf + A30 + vbCrLf + A31 + vbCrLf + A32 + vbCrLf + A33 + vbCrLf + vbCrLf + A34 + vbCrLf + A35 + vbCrLf + A36 + vbCrLf + A37 + vbCrLf + A38 + vbCrLf + A39 + vbCrLf + A40 + vbCrLf + A41 + vbCrLf + A42 + vbCrLf + A43 + vbCrLf + A44 + vbCrLf + A45
With DataObj
.SetText STR1
.PutInClipboard


End With

Unload UserForm10

MsgBox "Notepad copied to clip board"

End Sub


Sorry not sure if this is the format you are after i am quite new to this forum

[Norie]

Are A0, A1 etc the textboxes?

[brewsi]

yes they are. sorry i should have made that clear because the user form has different pages i labelled text boxes on each page different letters as identifiers.

[Norie]

Try this.

Please Login or Register  to view this content.

PS Can you add code tags when posting code?