Private Sub on the fly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

michael v - 21 Feb 2006 10:53 GMT

Is it possible to create this using code - not just writing the code below

Private Sub TextBox1_Change()
Cells(6, 18).Value = Application.Sheets("Sheet1").TextBox1.Text
End Sub

....but to put this code in as code using other code....:)

Reply to this Message

Norman Jones - 21 Feb 2006 11:01 GMT

Hi Michael,

See Chip Pearson's page on VBE programming at;

http://www.cpearson.com/excel/vbe.htm

---
Regards,
Norman

> Is it possible to create this using code - not just writing the code below
>
[quoted text clipped - 3 lines]
>
> ....but to put this code in as code using other code....:)

Reply to this Message

michael v - 21 Feb 2006 13:57 GMT

Thanx a lot....seems to be just what I needed...

> Hi Michael,
>
[quoted text clipped - 13 lines]
> >
> > ....but to put this code in as code using other code....:)

Reply to this Message