Populate a cell from a text box.

[Unknown_User]

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

 

[Chip Pearson]

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 >" <<[email protected]>
wrote in message
news:[email protected]...

 

[Unknown_User]

......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