How do you get a VBA code to reference the value of a cell in a worksheet and
use it in an equation? An example of what I'm trying to do is; If you click
on "Spring" I want B27=L175. If you click on "Spring w/Liftable" the
equation would then be B27=L175-K195.

Also, Is there a way to have a text box in a user form to read a cell? So
basically I would like the text box to have the same value as what is in K196.

Thanks for any help on this in advance.

Please don't post the same question in multiple forums. See the answer in the
programming forum. Check out this link...

http://www.cpearson.com/excel/newposte.htm
--
HTH...

Jim Thomlinson


"Cerberus" wrote:

How do you get a VBA code to reference the value of a cell in a worksheet and
use it in an equation? An example of what I'm trying to do is; If you click
on "Spring" I want B27=L175. If you click on "Spring w/Liftable" the
equation would then be B27=L175-K195.

Also, Is there a way to have a text box in a user form to read a cell? So
basically I would like the text box to have the same value as what is in K196.

Thanks for any help on this in advance.