$$Excel-Macros$$ Re: Check Box macro

2009-07-08 Thread Dave
Thank You Gents, fantastic as ever..so many ways to Skin A Cat On Jul 8, 1:27 am, "Ajit Navre" wrote: > Hi Dave, > > Please take a look at the attached workbook- hope this is what you are > looking for- > > (Start from the ThisWorkBook - WorkBookOpen Event Procedure.) > > Regards, > > Ajit > > >

$$Excel-Macros$$ Re: Check Box macro

2009-07-07 Thread Daniel
Hi Dave, You have more than a way to achieve this. It depends how many checkboxes you have. If you have few, associate the same code with each checkbox : Private Sub CheckBox1_Click() If [AL1] = True Then MsgBox "Please Fill the related Entities Spreadsheet, thanks" End If End Sub (AL1 being t