macro to toggle cell value

**martindwilson** · 10-18-2007, 10:54 AM

could anyone here provide simple macro i can assign to a button that will togglethe value of a specified cell to 1,0,or true/false,black/white or similar
pretty please!

oh dear now ive searched i found several options already availiabe,option button /scroll bar.

so simple really! so no code needed here thanx

**wmorrison49** · 10-18-2007, 11:19 AM

You could just write something that sees if a cell is one thing and if it is, switch it to the other. For example, if the cell is A1 and you wanted to toggle between 1 and 0, you could have:

Range("A1").Select
If ActiveCell = 1 Then
ActiveCell = 0
Else
ActiveCell = 1
End If

Is that what you mean?

**martindwilson** · 10-19-2007, 06:42 AM

thanx
Iassigned that to a button and it works a treat! toggles a1 1 or zero.
thats now stored in my "excel how did i do that folder "for future reference.

**wmorrison49** · 10-19-2007, 08:23 AM

Haha, I have one of those folders too. Glad it worked

**SESchmidt** · 11-28-2020, 12:49 PM

I have a conditional formatting set determined by the value of a cell being TRUE/FALSE.
I added a button to the quick toolbar using that macro, which works wonderfully. But, when I run it, the
sheet scrolls up to the cell. How can I eliminate that so it stays where I was? Thanks

**FDibbins** · 11-29-2020, 01:16 AM

Originally Posted by SESchmidt

I have a conditional formatting set determined by the value of a cell being TRUE/FALSE.
I added a button to the quick toolbar using that macro, which works wonderfully. But, when I run it, the
sheet scrolls up to the cell. How can I eliminate that so it stays where I was? Thanks

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

**jolivanes** · 11-29-2020, 02:51 AM

If you want to save some space for future keep sakes, either one will do.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**jolivanes** · 11-29-2020, 03:30 AM

@AliGW
The answer was to martindwilson!

Re: "thats now stored in my "excel how did i do that folder "for future reference."
In answer to this, I wrote what I wrote.