Get values from Controls in Excel-sheet

  • Thread starter Thread starter Trond Fugleberg
  • Start date Start date
T

Trond Fugleberg

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
 
worksheets("Sheet1").Range("A1").Value = _
Userform1.Textbox1.Value
 
The textbox is in the worksheet not in a userform! Else
your solution would have been perfect!

Regards Trond
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

userform exception error 4 textboxes 7
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text" 5
Error control dont work! 2
switch automatically between text boxes 4
Programming a new macro 4
Referring to control value on form using variable name for control 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
HELP: Unable to clear values for control of type text in a userfor 4

Back
Top