[RESOLVED] Pasting code to cell

[Sparky_GPR]

Hey all,

I have been working on a form for a log system on my work experience

This is what i have so far

Private Sub cmdDoIT_Click()
    
    If txtLogNo.Value = "1" Then
    If chkTaken.Value = True Then
        Memory.SetText txtQuantity.Value
        Memory.PutInClipboard
        Sheets("Brochures").Select
        Range("F4").Select

Can any1 tell me wat code comes next to paste wats on the clipboard to the cell F4???

Thanks