Hello
I got 2 checkboxes and I want to run a macro which depending on the value selected on the first checkbox will display a different information on a the second checkbox.
I got some questions:
--when I assign a macro to the checkbox (right click over checkbox-->assign macro), how can I access the current selected value of the checkbox?
--How can I redefine a different range to be taken by the 2nd checkbox depending on the value selected on the 1st checkbox?
Hi,
Presumably you're referring to the Excel checkbox control rather than the Activex UserForms controls in the VBE?
The view Code window of the checkbox is actually the Checkbox_Click event, and the default values are either True or False. e.g. put the following in the code
and see it toggle between True/False as you click the button. Hence you access the value by simply referring to it.
Please Login or Register to view this content.
I'm confused by your second question. Are you sure you really mean a checkbox? A checkbox can't 'take a range', it's essentially just a binary control. You can check the state of a checkbox and do things like naming a range according to its state, but in that case you'd presumably build that into the Checkbox 1 click event.
Can you explain a little further
Last edited by Leith Ross; 07-14-2008 at 03:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks