[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

[si_the_geek]

Is there a particular reason to be using the Clipboard?

If not, try this instead:

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

[Sparky_GPR]

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