Transferring Text Box Content to cell - Formula Help

  • Thread starter Thread starter Shashi Bhosale
  • Start date Start date
S

Shashi Bhosale

Hi Gurus,

I need a help with a formula which will transfer the content of text box to
a cell.
Text box could contain any number of characters.

Thanks in advance.
 
A UDF (in a module) such as this :

Function xx()
xx = UserForm1.TextBox1.Text
End Function

and then in the target cell, type =xx()

BUT: F9 does not update the cell if the text box has changed. !?

You could use

Private Sub TextBox1_Change()
Range("A1")=userform1.textbox1.text
End Sub
 
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

Control Text Box Data Transfer 2
Display cell contents in a text box (shape) and linking 2
Creating a formula in VBA with quoted strings 1
Populate Cell with Content of Text Box 10
A way to count cells in a range containing text or formulas 2
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
UserForm as Reader 3
select all cell containing any formula and not text or number 2

Back
Top