Bob Phillips wrote:
[b]Because you are tied to a worksheet, that is where it is gettin
the values
from.

Why not just change the worksheet cells directly, rather than the
textbox(es)?

That's what I had to do. I just thought it should work the other wa
too. It's a whole lot clearer to type:

txtInitialCost.Value = 44

than:

Thisworkbook.Range("B45").Value = 44

I was initializing up towards 50 values, so it would have been alo
easier

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