Posted by
Andy Brown
on 07 June 2023
One of the immediate and obvious ways to use AI tools is to boost your productivity as a programmer. This blog shows how you can use ChatGPT 4 and Google's Bard to write programs in SQL, Python, VBA, JQuery and Office Script (probably the 5 languages Wise Owl use most).
Posted by
Andrew Gould
on 31 January 2022
Have you played Wordle yet? You should, it's great! We're a bit obsessed with it at Wise Owl so Andrew, Andy and Sam have all been working their own versions of the game in VBA, Python and Power BI(!) respectively. Check out this quick intro to Andrew's VBA version.
Posted by
Andy Brown
on 02 February 2021
My aim in this blog is to show how you can go about building any computer system from scratch (and not just a word search in Excel VBA). Along the way I've included lots of hints and tips!
Posted by
Andy Brown
on 01 February 2021
Follow this blog to construct your own word search, complete with a missing phrase spelt out by the unused letters!
Posted by
Andy Brown
on 25 August 2020
You can have great fun taking your favourite image (a picture of your loved one?) and pixellating it in VBA. The results are stored as RGB numbers in a workbook - what you do with them then is up to you!
Posted by
Sam Lowrie
on 26 June 2020
Did you know that you can create Microsoft Team meetings using VBA in Outlook? This blog shows you how!
Posted by
Andy Brown
on 13 March 2020
What happens when you combine the magic of speech recognition with the power of VBA? A user form which you can fill in without a keyboard!
Posted by
Andy Brown
on 10 January 2020
After a huge investment of time and expertise, we're proud to announce that our first full online training course is now live on our website! The course shows you how to program in VBA in Excel, and is completely free (you don't even have to log in to follow it).
Posted by
Andy Brown
on 17 June 2019
Some people are experiencing problems when trying to suppress screen updates while macros are running in Excel VBA, under Windows 10. This blog gives one possible solution.
Posted by
Andy Brown
on 17 June 2019
When you discover a new short-cut key, should you share it? This blog shows a way to bring up Intellisense for the arguments to user-defined functions in Excel VBA.
Posted by
Andy Brown
on 26 September 2016
A short blog explaining how you can get Excel to read out values in cells every time that you recalculate a worksheet.
Posted by
Andy Brown
on 17 December 2015
This short blog shows that there is a third way to refer to a range, other than using the RANGE or CELLS keywords.
Posted by
Andy Brown
on 17 December 2015
There are two ways you can display an input box using Excel macros: the standard VBA InputBox function, or the much better (but lesser known, at least by this blog's author) Application.InputBox function.
Posted by
Andrew Gould
on 26 November 2015
You can give your VBA code a performance boost by simply turning off screen updating while your code runs. This blog explains how to achieve this and how to create a basic timer to test the results.
Posted by
Andy Brown
on 03 October 2014
Charts in VBA are a bit weird: this blogs highlights some of their foibles, by showing how charts are really just special shapes, which contain shapes of their own!
Posted by
Andy Brown
on 15 September 2014
I've already pinched (with permission!) the ideas of Fergus Cairns to explain ways to run automatic searches on popular websites like Google; this blog gives an update on the same topic.
Posted by
Andrew Gould
on 24 April 2014
This part of the tutorial explains how to add sounds to the game using a Windows API function.
Posted by
Andrew Gould
on 24 April 2014
This part of the tutorial implements a state system to make it easier to determine what actions to perform each time the game updates.
Posted by
Andrew Gould
on 24 April 2014
In this part of the tutorial you'll learn how to make the game detect collisions between the bird and the obstacles.
Posted by
Andrew Gould
on 24 April 2014
This part of the tutorial shows you how to add obstacles to the game and how to make them move across the screen.
