Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Control Source Property (2000)

    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
    <pre> =Master Settings!A1</pre>

    I get the error message "Invalid Property Value". However, if I change the name of the sheet to MasterSettings and the control source to
    <pre>=MasterSettings!A1</pre>

    the control source takes just fine. Go figure...

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control Source Property (2000)

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

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control Source Property (2000)

    That does not work unless the sheet is named "Master_Settings".

  4. #4
    Lounger
    Join Date
    Oct 2001
    Location
    Isleworth, Gtr London, England
    Posts
    28
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Control Source Property (2000)

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

    That should fix it.
    Glenn B

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control Source Property (2000)

    That works! Thanks Glenn...

  6. #6
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control Source Property (2000)

    Yes, thanks. I knew there was something! <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •