[RESOLVED] Pasting code to cell

Hey all,

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

This is what i have so far

VB Code:

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

Is there a particular reason to be using the Clipboard?

If not, try this instead:

VB Code:

Private Sub cmdDoIT_Click()
    
    If (txtLogNo.Value = "1") And (chkTaken.Value = True) Then
        Sheets("Brochures").Range("F4").Value = txtQuantity.Value 
    End If
...
End Sub

No just thats the first way i could think of doing it, that code worked wicked, cheers m8