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!
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 […]
While using an open text list, this will set the max length of each of the fields in the list, as standard confirmit will set the length for all of the fields with one box, use this if each one differs in length. My open text list is called ContactDetails document.getElementById(“ContactDetails2_Main”).maxLength = “20“; document.getElementById(“ContactDetails2_Alt“).maxLength = “25“; […]