Control Source Property (2000)

Topic

New Reply

You know, I just realized after wrestling with the control source property of a textbox for more than a few minutes…you cannot set the control source to a cell on a sheet which has a name consisting of two words. If I tried to set the control source to

 =Master Settings!A1

I get the error message “Invalid Property Value”. However, if I change the name of the sheet to MasterSettings and the control source to

=MasterSettings!A1

the control source takes just fine. Go figure…

Reply | Quote

Replies

I do believe, but cannot be sure without testing, that you could put =Master_Settings!A1

Reply | Quote

That does not work unless the sheet is named “Master_Settings”.

Reply | Quote

use single quotes around the two words of the sheet name, as in
=’Master Source’!A1

That should fix it.
Glenn B

Reply | Quote

That works! Thanks Glenn…

Reply | Quote

Yes, thanks. I knew there was something!

Reply | Quote