Very basic VBA question.

[Cerberus]

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.

 

[Jim Thomlinson]

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