Get values from Controls in Excel-sheet

Trond Fugleberg · Jun 16, 2004

Hi!

I have a textbox from the Controls in my spreadsheet. How
can I get/copy the value from this textbox to a cell in my
spreadsheet?

BR
Trond

Tom Ogilvy · Jun 16, 2004

worksheets("Sheet1").Range("A1").Value = _
Userform1.Textbox1.Value

Trond Fugleberg · Jun 18, 2004

The textbox is in the worksheet not in a userform! Else
your solution would have been perfect!

Regards Trond