Text Box Colour Changes when clicked

[waqasshah]

Dear All,

I am trying to create a dashboard with 3 buttons. By default when the sheet loaded they all have same colour. when I clicked on one button the colour of the button changes. when I cliked on second button the other two remain same. I have tried but no luck can you please help ? Please review the screenshoots.

Thanks

Waqas Shah

[rubenmarin1]

Hi Waqas, this can be done using a variable, each button sets a variable to 1, 2 or 3, or 0 if the variable already has the pressed value, ie, for button 1 the value can be set as:

If(varName=1, 0, 1)

The text box colour for this button can be set as:

If(varName=1, color1, color2)

Same for 2 and 3, so only the button with the same number has color1, if varName=0 all buttons have color2.

If more than one button can be 'active', each button needs it's variable that switches between 0 and 1.

[its_anandrjs]

Create three variables for setting values for three buttons and on click make a change in the colour of the button of your choice red or blue.

Find the attached for more details.

[waqasshah]

Thanks You

[waqasshah]

Thank You

[waqasshah]

Thanks But that will apply on text box as well ? because you have used buttons not text box object

[its_anandrjs]

This are buttons just change properties >> background >> Aqua

See attached also

[avinashelite · Accepted solution]

See the attachment for the solution

[waqasshah]

Secondly the issue is with the second text box it wont work. I have attached the file please review it

[waqasshah]

Thanks You Avinash