I've grabbed a bit of VB code from the internet that I thought would be handy for work. I've Office 2010 at home and it works fine.
Got to work today, entered the VB code, and I get an error message in the 'MsgBox' line. Here's the code:
My work runs Office 2003. The error highlights the &F.Row&, the "is either within 30 days..." quote, vbLf & _ and vbExclamation + vbYesNo, "Expiry Alarm" areas.
I don't really know Visual Basic (Done the normal Basic a while ago) but I'm familiar with some of the commands. I tried playing about with it today, but with little/no knowledge of VB, I'm stumped.
If anyone with VB knowledge here can help me out it would be gratefully appreciated. I've looked around the internet with no joy
Thanks in advance,
snapman
Got to work today, entered the VB code, and I get an error message in the 'MsgBox' line. Here's the code:
Code:
You don't have permission to view the code content. Log in or register now.
My work runs Office 2003. The error highlights the &F.Row&, the "is either within 30 days..." quote, vbLf & _ and vbExclamation + vbYesNo, "Expiry Alarm" areas.
I don't really know Visual Basic (Done the normal Basic a while ago) but I'm familiar with some of the commands. I tried playing about with it today, but with little/no knowledge of VB, I'm stumped.
If anyone with VB knowledge here can help me out it would be gratefully appreciated. I've looked around the internet with no joy
Thanks in advance,
snapman