label controls

Posted by Leigh on January 03, 2001 2:30 PM

I have a couple of text boxes on a vba form, related to relavent cells on a worksheet, using the Range("A1").value = textbox1.value syntax. I would now like to display the result of the calculation in a label control on the from, is this possible?

Posted by Dave on January 04, 2001 2:03 AM

Hi Leigh

It certainly is, you use the .Caption property like below:

[A1] = Label1.Caption

You can also make a Textbox look the same as a Label by changing the SpecialEffect property to O - FmSpecialEffectFlat and the Backcolor to grey.

Dave

OzGrid Business Applications