Making a cell mandatory

**Abgirl** · 07-12-2010, 02:04 PM

Hi All,

Need some help with inserting an extra bit of VB code to an existing sub please?

I've attached a sample sheet with the VB behind the button as per the real sheet - basically need the code to check if a cell (Date to be Actioned) is filled before running the rest of the sendmail code?

Could someone help me out with this one please as I am a real newbie to VB!

Thanks in advance guys!!

**jaslake** · 07-12-2010, 02:54 PM

Hi Abgirl

Probably something like this

Please Login or Register  to view this content.

Hope that helps.
John

**Abgirl** · 07-19-2010, 09:36 AM

Hi,
thanks fir this - but when I try to add this in, i get an error about the 'IF' and also about comments after an END SUB?
It is me putting something in wrong I have no doubt!