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" <ASU@discussions.microsoft.com> a écrit dans le message de news:
45523BAB-A58C-47BD-AFEC-C98B5E4AEFAB@microsoft.com...
> 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" <ASU@discussions.microsoft.com> a écrit dans le message de news:
> 45523BAB-A58C-47BD-AFEC-C98B5E4AEFAB@microsoft.com...
> > how do I paste the value of a textbox in a userform to a active cell in a
> > spreadsheet.
> > --
> > ASU
>
>
>