Pop up Message box
Hi all
I need a little bit of help as my programming knowledge is shall we say a little lacking! On my spreadsheet it became necessary to flag one in every 5 specific deals, i currently have the spreadsheet set up to count the said specific deals with this formula, =COUNTIF(J32:J221,"Self Cert") then in the next cell the following formula that displays a message in this cell =IF((MOD((B6),4))=0,"Audit Next Case"). However i feel that some people are missing this little message so what i would like to do it have a pop up box that they have to click €˜ok to get rid of that will appear on every 5th self cert case. If someone could give me, some code to do this and where to enter said code i would be most grateful. Thank you for your time |
Pop up Message box
You can look at Data=Validation. There are options there for popping up
such a window when a cell is selected. You can turn on the macro recorder while you apply that formatting manually, then turn it off and look at the recorded code. -- Regards, Tom Ogilvy "tuk16664" wrote: Hi all I need a little bit of help as my programming knowledge is shall we say a little lacking! On my spreadsheet it became necessary to flag one in every 5 specific deals, i currently have the spreadsheet set up to count the said specific deals with this formula, =COUNTIF(J32:J221,"Self Cert") then in the next cell the following formula that displays a message in this cell =IF((MOD((B6),4))=0,"Audit Next Case"). However i feel that some people are missing this little message so what i would like to do it have a pop up box that they have to click €˜ok to get rid of that will appear on every 5th self cert case. If someone could give me, some code to do this and where to enter said code i would be most grateful. Thank you for your time |
All times are GMT +1. The time now is 09:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com