Here is the Bitcoin/Cryptocurrency MoDCore referral page. Below is a selection of sites to gain free coins in order of our favourite ones. JSEcoin – Browswer Mining Jsecoin Mining – Web Masters JSEcoin is great for webmasters who own a website. On this site you can mine coins using your browswer or add in script […]
Add Print & date to reportal Page
Here is a quick and simple way to add in a print link and date to a reportal page. The print this page is a link which will open up the print dialog in your browser. Example below Script below <div class=”noprint”><a class=”strapline” href=”javascript:window.print()”>Print this Page</a></div> <script language=”Javascript”> <!– var now = new Date(); var […]
Clear or Reset Cells on your Form
This is some simple code to either “Reset” a user entry workbook or to clear cell values before / after use or on command. In this example the “reset” is connected to a button for the user once complete will show a message box “Worksheet Reset”, then to move the cursor to Cell C19 ready […]
Working out SLA Breaches with Excel!
Looking for a simple way to keep track of task and dates? This will help you keep track of SLA’s for a given task, log or project, when handy when dealing with a selection of items. We will guess that the threshold is 8 working days, we can then get Excel to display if the […]
Show and hide sheets based on user
This is a handy bit of code for a simple show and hide command, using the “Windows Username in a cell” code with this show/hide code is a great feature for any workbook used by a teams or departments that have different jobs within the workbook. This is a private sub and will activate on change […]
Developer Tab and VBA Starting Point
Developer and VBA Starting Point Firstly you will want to add in the Developer tab to your excel ribbon. File > Excel options > Customise Ribbon Tick the Developer Option. Adding a button to a page Many of the VBA scripts we use here start with a button, here is how to add the […]
MS Access – Convert SQL > VBA
SQL Query Into to VBA Language – The Converter This process will enable to you build a SQL query to VBA converter. As VBA cant work with a direct paste of SQL into the VBA scripts this convert will add it line by line with the correct quotation marks and joins. Steps to produce – […]
Excel Conditional Formatting
Conditional Formatting – The basics Quick start! By applying conditional formatting to your data, you can quickly identify variances in a range of values with a quick glance. This is showing 3 items by number over a year. Red for the low scores, Green for the top scores. How To! Select the data you want […]
Update all Pivots and Graphs – One Button
Update all Pivots and Graphs – One Button This code will Update all pivot tables and pivot graphs in the entire workbook, which will save time in manually updating all tables, sheets and graphs! Open the Developer tab – Click here to see how to, we use this tab allot. – The starting point Pop the […]
Add desktop shortcut to URL – VBS
This is a simple VBS script that will add a desktop shortcut for a URL to a users PC. Change the parts in bold Set objShell = WScript.CreateObject(“WScript.Shell”) ‘All users Desktop allUsersDesktop = objShell.SpecialFolders(“AllUsersDesktop”) ‘The current users Desktop usersDesktop = objShell.SpecialFolders(“Desktop”) ‘Where to create the new shorcut Set objShortCut = objShell.CreateShortcut(usersDesktop & “\SHORTCUTNAME.url”) ‘What does […]