Pasting selected text to clip board if checkboxs are true in VBA

[markda2000]

Hi,

I have a user form that will paste to clipboard the entries from the user form when a button in pressed. However it only shows the value of checkboxs being true or false which does not read easily (the purpose of the form is to paste into customer service advisors notes).

Is there anyway to have the copied item display text if the checkbox is checked and nothing if not. I guess I need to be using the IF function but I cannot get it to work.

Part of the code I have is below

Private Sub SaveNotesButton_Click()
Dim notestosendtoclipboard As String
Dim textobj As DataObject
Set textobj = New DataObject

notestosendtoclipboard =     "Paying by direct debit " & PayingByDD.Value 
textobj.SetText notestosendtoclipboard
textobj.PutInClipboard

End Sub

Sorry if this seems basic but I am very new at VBA

 

[RoryA]

Something like:

If Me.Checkbox1 then
' your code here
End If

 

[markda2000]

thanks for your reply Rorya, I seem to be having problems with the code that you gave me.
I think I may have over simplified the smaple code I posted though.

I have other lines of text to be pasted to the clipboard as well and three of these lines of text are to be dependant on the values of three checkbox's. when I put the If statement in the line of code where I want the Then text to be displayed I get a sytax compile error.

I am as you can tell very new to VBA and am struggling with the most basic tasks.