Forms: >Variable< ControlSource for checkbox?

[tx12345]

Hi

in the most basic userform with a checkbox, one can go to the ControlSource section of the checkbox object's properties and type in "A1" where each time the check box is selected A1 will then say "true".

But what if I want the ControlSource for the checkbox tied to a value in B1, for example. Thus when B1=2 then the controlsource for the checkbox will change to A2.

TIA!

tx

 

[tusharm]

Create a named formula (Insert | Name > Define...) For my test, I used
IndirectSource =INDIRECT("'Sheet2'!A"&Sheet2!$B$1) Note that I was using Sheet2 for my test.

Now, specify the control source as book1!indirectsource where book1 is the workbook name. For my test, I was using an unsaved workbook.

 

[tx12345]

looks good. thanks.

 

[tusharm]

You are welcome.

 

[tx12345]

hi

i just gave your code a try and the error message was "could not set the controlsource property. invalid property value"

any thoughts?