Control Source Property

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

donh - 10 Aug 2007 15:23 GMT

Hi Group,

I'm using the control source property in VBA to link a form text box
to a worksheet cell. Although this works I have found that the
worksheet cell is overwritten by the form textbox (even if not updated
within the form, I set the locked property to true) when the form
closes. The problem being that the worksheet cell data is a lookup
formula and not just plain text! So each time it closes I lose my
formula!

Can someone point me in the right direction please.

Thanks in anticipation

DonH

Reply to this Message

Dave Peterson - 10 Aug 2007 16:53 GMT

If you want to retrieve the value from the cell for use in the userform, then
use code to grab the contents.

Maybe in the userform_initialize procedure:

me.textbox1.value = worksheets("sheet9999").range("a999").text

If you want to put the value from the textbox back to the cell, then you're
going to lose the formula.

> Hi Group,
>
[quoted text clipped - 11 lines]
>
> DonH

Signature

Dave Peterson

Reply to this Message

donh - 10 Aug 2007 17:17 GMT

> If you want to retrieve the value from the cell for use in the userform, then
> use code to grab the contents.
[quoted text clipped - 27 lines]
>
> - Show quoted text -

Thank you Dave, I shall give that a try. I've been having a go using
ListBox's instead. They seem to work, but don't know if I'm building
up more problems using them.

Thanks again.

DonH

Reply to this Message