Checkbox question.

thewiseguy

Well-known Member
Joined
May 23, 2005
Messages
820
Office Version
  1. 365
Platform
  1. Windows
Hi everyone,

I am creating a worksheet which will detail 3 options for my sales reps to use for putting together a business proposal. Each option has a number of factors (i.e cost, margin, labor etc). Is there a way for the checkbox to work as an "activator" so that if I choose Option 2, the data in Option 2 will get moved to a highlighted area?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
You can do it a few ways in VBA and at least one way using formulas.

Need more information, like, which type of checkboxs you are using and where the information is now and where you want it after a box is checked.

You can make the variable data portion dependent upon the value of the checkbox, nesting all three of the checkboxs in an if statement, so that cell will only show information, if one of the checkboxs is checked. Then re-do this for each of the cells that get this variable information.


See here:

http://www.mrexcel.com/board2/viewtopic.php?t=255691
 
Upvote 0

Forum statistics

Threads
1,191,686
Messages
5,988,066
Members
440,125
Latest member
vincentchu2369

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
Top