Create "Click Buttons" That changes a cell Background Color and Text Color once 'clicked'

Josimathe

New Member
Joined
Sep 20, 2015
Messages
2
How do I change a cell into a "click button?" I manage several locations and am creating a task sheet. I want to be able to "click" which location I am logging tasks for at the top of each sheet. I would appreciate the help.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
You want to click on a cell and run a script is that what you want. if not explain what you want to happen when you click a particular cell.
 
Upvote 0
You want to click on a cell and run a script is that what you want. if not explain what you want to happen when you click a particular cell.

I have a series of cells...no fill color with black text. They represent locations that I manage. I want to 'select' the location I am creating the worksheet for by clicking the cell(s) that represent the location I am filling in data for. Once clicked I want the fill color to change to grey and the text color to BOLD white. If I click it again, I want the original cell rules to apply.
 
Upvote 0
I still do not understand what your wanting.
What is in the cell you want to click on.
I want to 'select' the location I am creating the worksheet for by clicking the cell(s) that represent the location
do you mean you have A1:C:40 for example in cell "A1"
 
Upvote 0

Forum statistics

Threads
1,215,353
Messages
6,124,464
Members
449,163
Latest member
kshealy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top