Home |
Search |
Today's Posts |
#1
|
|||
|
|||
checkbox
I have an excel spreadsheet with several checkboxes, I would like to know how
to deselect certain checkboxes when one is selected. Also is ther anyway to have a popup window with text information come up when a check box is selected? Thanks in advance |
#2
|
|||
|
|||
activesheet.checkboxes("Check Box 1").value = false
-- HTH RP (remove nothere from the email address if mailing direct) "Chas" wrote in message ... I have an excel spreadsheet with several checkboxes, I would like to know how to deselect certain checkboxes when one is selected. Also is ther anyway to have a popup window with text information come up when a check box is selected? Thanks in advance |
#3
|
|||
|
|||
Hello
You probably need option buttons if you need this functionality. Have you considered them? Also to show a pop-up, you have to first create a UserForm and then invoke its startup code in a macro. The code for invoking a UserForm is UserForm1.Show Alok Joshi "Chas" wrote: I have an excel spreadsheet with several checkboxes, I would like to know how to deselect certain checkboxes when one is selected. Also is ther anyway to have a popup window with text information come up when a check box is selected? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy many CHECKBOX | Excel Discussion (Misc queries) | |||
How do I make a checkbox bigger? | Excel Discussion (Misc queries) | |||
Checkbox | Excel Worksheet Functions | |||
Checkbox not part of cell. (???) Cells can move "underneath". (!!!) | Excel Discussion (Misc queries) |