Populate a cell from a text box.
 

Hi all,

No doubt a simple question!

I have a vb form into which the user types a value.

Various calculations happen in the vb code which produces a string.

I want to place that string into a cell on a worksheet. Does anybod
know how to do it?

Thanks

--
Message posted from http://www.ExcelForum.com

Populate a cell from a text box.
 

Just use something like

Worksheets("Sheet1").Range("A1").Value = the_string_variable


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Unknown_User "
wrote in message
...
Hi all,

No doubt a simple question!

I have a vb form into which the user types a value.

Various calculations happen in the vb code which produces a
string.

I want to place that string into a cell on a worksheet. Does
anybody
know how to do it?

Thanks!


---
Message posted from http://www.ExcelForum.com/

Populate a cell from a text box.
 

......thanks!

I feel good 'cos I've tried to work this out for ages.

I feel dumb 'cos the answer is so simple.

Thanks again

--
Message posted from http://www.ExcelForum.com