checkbox

C

Chas

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
 
B

Bob Phillips

activesheet.checkboxes("Check Box 1").value = false

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
A

Alok

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
 
Top