All code can be found here for Excel, Confirmit, Now-TV, Access and VBS.
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 […]
Faerie Solitaire is a video game created and developed by independent video game developer and publisher Subsoap. The game was released 15 March 2009. This game mixes solitaire elements with fantasy and role-playing game elements. First ranked match about 10 mins of owning the game….Didnt go well!
Here is the parent page for the MoDCore Streaming! So far we have a couple of games feature! >>Forums if you have any suggestions! <<
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 […]
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 […]
Dynamically Change Pivot Table Source Data This is a handy bit of code which will save you having to update the source range of a pivot table each time new data is added to the table. In this example I have a data sheet called “Data”. Each month new row’s are added to the table. […]
Extract Month from a date There are a couple of ways to extract just the month from a date in excel. Here are the 2 major ways it can be done. =Month() =MONTH(A2) – returns the month of a date in cell A2. =MONTH(DATE(2015,4,15)) – returns 4 corresponding to April. =MONTH(“15-Apr-2015”) – obviously, returns number […]
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 […]
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 – […]
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 […]