ExcelBanter - pasting textbox value to active cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pasting textbox value to active cell (https://www.excelbanter.com/excel-discussion-misc-queries/95171-pasting-textbox-value-active-cell.html)

ASU

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

Ardus Petus

pasting textbox value to active cell

Activecell.Value=Userform1.TextBox1.Value

HTH
--
AP

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

ASU

pasting textbox value to active cell

Thanks very much. It works nicely.
--
ASU

"Ardus Petus" wrote:

Activecell.Value=Userform1.TextBox1.Value

HTH
--
AP

"ASU" a Ã©crit dans le message de news:
...
how do I paste the value of a textbox in a userform to a active cell in a
spreadsheet.
--
ASU

All times are GMT +1. The time now is 02:22 PM.