pasting textbox value to active cell

Guest · Jun 21, 2006

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

Ardus Petus · Jun 21, 2006

Activecell.Value=Userform1.TextBox1.Value

HTH

Guest · Jun 23, 2006

Thanks very much. It works nicely.
--
ASU

Ardus Petus said:
Activecell.Value=Userform1.TextBox1.Value

HTH

Link a textbox on a sheet to a cell?!	2	Mar 26, 2010
search a value in W/sheet	7	Apr 1, 2009
Add Value from Textbox to next cell in range	2	Feb 16, 2009
Macro for Calendar	1	Feb 24, 2010
Access Dateadd function question..	0	Sep 1, 2019
Activating hyperlinks	3	Jun 17, 2014
Excel Displaying content from excel sheet onto textbox in userform	0	Feb 7, 2017
Textbox linked to a cell	2	Mar 28, 2008

Ask a Question