Option Group & Other Worksheet

A

Andy Roberts

I have an option group linked to cells which display TRUE or FALSE depending
on the option selected. Im looking to have another option group on a
different worksheet change based on the selection in the first group.

eg if the option group on "Sheet1" had cell A1 as TRUE, then I want the cell
A1 on Sheet 2 to change to FALSE. I want to do this through VBA and not via
a formula in A1 of Sheet2 as the option group linked to A1 on Sheet2 would
overwrite the formula when I use that option group.

Hope that makes sense

Andy
Office 2013
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a macro only work on certain files 2
VBA for Dependents shortcut menu 0
VBA Coding Help for Beginner 0
VBA word change keys 0
Duplicating cell values from one sheet to another 3
Word macro that can call cells out of Excel for a find and replace 0
Option Groups: Can I Group the Buttons AND the Box They're In? 2
combo box 0

Top