This page has 1 thread | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Blog topic: General programming in VBA

Showing blogs 1-17 (out of 17)

Coding in SQL, Python, VBA, JQuery and OfficeScript using AI tools

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).

Tags:
SQL > General Python > Progamming VBA macros > General Client script > JQuery Office Scripts > General

Wordle in Excel VBA

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.

Tags:
VBA macros > General

Building a word search system in Excel VBA

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!

Tags:
VBA macros > General

Using the WOWSER Excel VBA system to build a word search

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!

Tags:
VBA macros > General

How to have fun pixellating and reconstructing images in VBA

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!

Tags:
VBA macros > General

Use VBA to create Microsoft Team meetings

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!

Tags:
VBA macros > General

Talking to Excel to fill in your input forms, using speech recognition and VBA

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!

Tags:
VBA macros > General

Announcing the first Wise Owl online training course (Excel VBA)

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).

Tags:
VBA macros > General

Problems with the Application.ScreenUpdating = False command in VBA

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.

Tags:
VBA macros > General

Disabling Screen Updates in Excel VBA

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.

Tags:
VBA macros > General Writing VBA > Other

How to create autoshapes, lines and connectors in VBA macros

Posted by Andy Brown on 25 January 2014

You can use Visual Basic within Excel, PowerPoint or Word to draw shapes, format them and even assign macros to run - this long blog gives lots of ideas of how to proceed!

Tags:
VBA macros > General Writing VBA > VBA tutorial

Writing recursive programs in VBA

Posted by Andy Brown on 20 February 2012

In certain cases in VBA (displaying the contents of folders, listing hierarchical data) writing a program which calls itself is by far the easiest way to go - this blog gives worked examples of 3 such recursive programs.

Tags:
VBA macros > General Writing VBA > VBA tutorial

Collections, objects, methods and properties in Excel VBA

Posted by Andy Brown on 07 July 2023

Visual Basic for Applications (VBA) is what's called an object-orientated programming language. This blog explains what this means!

Tags:
VBA macros > General Writing VBA > VBA tutorial

Free VBA training tutorial

Posted by Andy Brown on 16 August 2011

As well as running introductory and advanced VBA training courses in the UK for small groups, we've also published this online training course teaching how to code macros using Visual Basic for Applications (VBA) within Excel. The tutorial covers everything from basic recording through to creating classes - something for everyone!

Tags:
VBA macros > General Writing VBA > VBA tutorial

Introduction to Visual Basic for Applications (VBA)

Posted by Andrew Gould on 01 July 2011

If you've heard people in your office talking about macros or VBA but don't understand what they mean, this blog series will make everything clear. It's an introduction to the most basic skills you'll need to start creating your own programs in any of the Microsoft Office applications.

Tags:
Writing VBA > Other VBA macros > General

Using sheet codenames in Microsoft Excel VBA

Posted by Michael Allsop on 01 June 2011

Do your macros keep falling over due to users renaming their worksheets in Excel? Read this article to find out if sheet codenames could be the solution you need.

Tags:
VBA macros > General Writing VBA > Other

Commenting out code in VBA

Posted by Andy Brown on 28 April 2011

Commenting code is an art form! This series of blogs explains why, how and when to comment in VBA.

Tags:
VBA macros > General Writing VBA > VBA tutorial

Some other pages relevant to the above blogs include:

This page has 1 thread

Add a new post

From:	zeno
When:	15 Mar 17 at 16:36

Reply to zeno

Dear Andrew et al I have been studying and enjoying your amazing videos for quite a while a while. I managed to (1). Create a payment system with vba code with application inputbox (2). I created vba code to review the payment system in (1) to ensure accuracy of date entry.

The first problem I have now is that when I run the review code and if no change was made to the payment entry in (2), the original entry are being changed to either '£0' or 'false' I have been scouting through the internet for solution to no avail. Please what vba code to write so that the original entry is not changed if no change is made at the review code stage?

The second problem I have is with the following code:

ActiveCell.Value = PaymentAddress
    Worksheets("PCN Form").Select
        For Each Cell In Selection
              Do
            If ActiveCell = "" Then Exit Do
        Cell.Value = UCase(Cell.Value)
        On Error GoTo 0
   Exit Sub
Loop
Next Cell

Application.DisplayAlerts = True
Application.ScreenUpdating = True

On Error GoTo 0

End Sub

When I place this code at the begining or middle or procedure, it stops after running without completing other procedures. I have therefore being constrained to put this procedure at the end. Otherwise, would prefer to bring it in the middle.

The third problem I have is how to write a vba code to validate a payment_reference to contain alphanumeric and also not more than 10 digits.

Can't thank you enough for your amazing videos. Keep us tuned! Kindest regards Zeno

From:	Andrew G
When:	16 Mar 17 at 09:01

Reply to Andrew G

Hi Zeno,

Thanks for your comments and questions. Your first question is difficult to answer as you haven't shown the code that you've written. I'd suggest using an IF statement to check whether the new value is different to the old value and only write changes to the cell if that is true.

For your second question I have to admit that it's quite difficult to work out what it is you're trying to do! Some of the code you've written, particularly the Do Loop and Exit Sub statements, appear to be unnecessary. If you're simply trying to change the value of a single cell to upper case text then the only line that you need would be something like this:

ActiveCell.Value = UCase(ActiveCell.Value)

For your third question you'll need to know a little about manipulating strings. Fortunately, we have a few videos on this topic. You may find these ones useful:

https://www.wiseowl.co.uk/vba-macros/videos/vba-functions/working-with-strings/

https://www.wiseowl.co.uk/vba-macros/videos/vba-functions/asc-chr-functions/

I hope that helps!

Add a new post

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BY TOPIC

EXCEL / VBA BLOGS

VBA MACROS BLOGS

Blog topic: General programming in VBA