a macro on a button to switch between the text FALSE and TRUE on a separate sheet

Sorry if this has been asked before but I have searched to the best of my ability in the forums and not found the answer I need.

What I need is for a macro that will be attached to a button that switches the text in a cell from a separate worksheet (same workbook) from the text "TRUE" to "FALSE".

e.g. Text in sheet2, B11 currently reads "FALSE" > Clicks button on sheet1 > text in sheet2, B11 now reads "TRUE" > Clicks button on sheet1 again > text in sheet2, B11 now reads "FALSE"

I haven't really learnt programming that much but I do understand the basics.

So far I've tried adapting the code from http://www.excelforum.com/excel-prog...le-on-off.html to fit my use but it only works for the first click (which in this case was turning B11 from "TRUE" or a blank cell to "FALSE") but did not change when clicked a second time.

Here's the code I changed it to (which is probably completely wrong due to me not being savvy with programming):

Please Login or Register  to view this content.

Only the code from beneath the "'Action 1 e.g.:" comment to the "Sheets(Item Selector").Select" worked. I need it to turn the text back to "TRUE" after clicking a second time then back to "FALSE" on a third click, etc.

Please help. I would appreciate an answer ASAP, please. I don't mind if a completely new code is needed, I just want the button to work how I want it to.

To toggle:

Please Login or Register  to view this content.

I've used the code given by gmr4evr1 because I understood it better. It worked and thank you so much :D. Thank you to the rest of you as well for giving me help as well so soon, I appreciate it a lot .

Thanks for the feedback. Fyi, the logic behind my code is that True = Not False (and likewise, False = Not True). So if B11 = True then Not True will be False.

Thanks for letting me know the logic behind your code berlan. Like I mentioned before when I posted the query, I'm not a programmer and only have a basic understanding of it so your explanation is very educational for me. Thanks again .