Friends I'm using Excel 2003 and on msform I have a simple textbox named txtFirstNo. Sometimes (I could not repeat problem bymyself) I get the error message 'Could not set the ControlSource property. Invalid property value' to an assignment statement:
txtFirstNo.ControlSource = dbInfo!E21. I have other text boxes whose control source set manually. They work perfectly fine. But this one gives me trouble.
Any Idea why?

Ömer Ayzan

Try :
txtFirstNo.ControlSource = Worksheets("dbInfo").Range("E21").address
as ControlSource requires a string.

NickHK

"Ömer Ayzan" <(E-Mail Removed)> wrote in message
news:e4y70ZL$(E-Mail Removed)...
Friends I'm using Excel 2003 and on msform I have a simple textbox named
txtFirstNo. Sometimes (I could not repeat problem bymyself) I get the error
message 'Could not set the ControlSource property. Invalid property value'
to an assignment statement:
txtFirstNo.ControlSource = dbInfo!E21. I have other text boxes whose
control source set manually. They work perfectly fine. But this one gives me
trouble.
Any Idea why?

Ömer Ayzan

As an aside, best to use an external reference

txtFirstNo.ControlSource =
Worksheets("dbInfo").Range("E21").address(,,,True)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"NickHK" <(E-Mail Removed)> wrote in message
news:eJoQ4dL$(E-Mail Removed)...
> Try :
> txtFirstNo.ControlSource = Worksheets("dbInfo").Range("E21").address
> as ControlSource requires a string.
>
> NickHK
>
> "Ömer Ayzan" <(E-Mail Removed)> wrote in message
> news:e4y70ZL$(E-Mail Removed)...
> Friends I'm using Excel 2003 and on msform I have a simple textbox named
> txtFirstNo. Sometimes (I could not repeat problem bymyself) I get the
error
> message 'Could not set the ControlSource property. Invalid property
value'
> to an assignment statement:
> txtFirstNo.ControlSource = dbInfo!E21. I have other text boxes whose
> control source set manually. They work perfectly fine. But this one gives
me
> trouble.
> Any Idea why?
>
> Ömer Ayzan
>
>