pasting textbox value to active cell

how do I paste the value of a textbox in a userform to a active cell in a
spreadsheet.
--
ASU

Activecell.Value=Userform1.TextBox1.Value

HTH
--
AP

"ASU" <[email protected]> a écrit dans le message de news:
[email protected]...
> how do I paste the value of a textbox in a userform to a active cell in a
> spreadsheet.
> --
> ASU

Thanks very much. It works nicely.
--
ASU


"Ardus Petus" wrote:

> Activecell.Value=Userform1.TextBox1.Value
>
> HTH
> --
> AP
>
> "ASU" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > how do I paste the value of a textbox in a userform to a active cell in a
> > spreadsheet.
> > --
> > ASU
>
>
>