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

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

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