Blogs from Wise Owl on Other in Writing VBA (page 1 of 2)

Showing blogs 1-20 (out of 21)

How to get Excel to read out cell values on calculation

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.

Tags:   Writing VBA | Other    |    VBA macros | Working with ranges

Referring to a range using square brackets

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.

Tags:   Writing VBA | Other    |    VBA macros | Working with ranges

This blog explains the lesser known but better Excel VBA InputBox function

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.

Tags:   Writing VBA | Other    |    VBA macros | Input/message boxes

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

Installing the Microsoft Date and Time Picker for VBA

Posted by Andrew Gould on 24 February 2015

Some versions of Windows don't include the very useful Date and Time Picker control. This blog explains how to install the mscomct2.ocx file to get it back!

Tags:   VBA macros | User forms    |    Writing VBA | Other

How to insert ActiveX controls after CANNOT INSERT OBJECT message

Posted by Andy Brown on 29 January 2015

When using Excel, we owls have had problems inserting ActiveX objects after recent security updates. Here's a solution which worked for us!

Tags:   VBA macros | User forms    |    Writing VBA | Other

Programmatically searching websites using VBA

Posted by Andy Brown on 19 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.

Tags:   VBA macros | References    |    Writing VBA | Other

Advice on how to scrape tables of data or HTML from webpages using VBA

Posted by Andy Brown on 13 January 2014

You can use VBA to extract data from web pages, either as whole tables or by parsing the underlying HTML elements. This blog shows you how to code both methods (the technique is often called "web-scraping").

Tags:   VBA macros | References    |    Writing VBA | Other

Getting the Calendar control to work in Excel 2010 onwards

Posted by Andy Brown on 13 January 2014

The calendar control for user forms is built into versions of Excel up to 2007, but has to be imported for later versions - this blog shows how to do this!

Tags:   VBA macros | User forms    |    Writing VBA | Other

How to use environment variables like USERNAME in VBA

Posted by Andy Brown on 25 November 2013

You can get at all sorts of system information within Visual Basic for Applications by using environment variables - this blog shows you how to get at your user's name, computer name and much more besides.

Tags:   VBA macros | Variables, arrays    |    Writing VBA | Other

How to loop over enumerations in VBA

Posted by Andy Brown on 07 November 2013

A short blog explaining how to use Visual Basic for Applications to loop over enumerations.

Tags:   Writing VBA | Other    |    VBA macros | Enumerations

Want to wind up your neighbour? Try this annoying Excel VBA code!

Posted by Andy Brown on 14 May 2013

If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it!

Tags:   Writing VBA | Other    |    VBA macros | Events

Problem with using VBA to create chart labels

Posted by Andy Brown on 04 April 2013

If your chart has more than a thousand data labels, this blog explains why you may experience problems.

Tags:   Excel | Charts    |    Writing VBA | Other    |    VBA macros | Working with charts

Using Excel VBA to Label Multiple Series in a Chart

Posted by Andrew Gould on 30 May 2012

This follow-up article to a previous blog describes how to label the data points in multiple series in Excel using VBA.

Tags:   Writing VBA | Other    |    VBA macros | Working with charts

How to Delete Digital Certificates from your Computer

Posted by Andrew Gould on 06 March 2012

Creating a digital certificate for your VBA projects is easy, but deleting them is somewhat less obvious. This blog shows you how to use the certificate manager to remove certificates that you no longer need.

Tags:   VBA macros | General    |    Writing VBA | Other

Using VBA in Microsoft Project to Set Up Unusual Calendars

Posted by Andrew Gould on 01 July 2011

Setting up a pattern of working time in a Project calendar is simple enough when your week runs from Monday to Sunday, but when you have an unusual working pattern setting up the calendar is a pain! This article explains how to use VBA to create a detailed calendar at the click of a button!

Tags:   Project | Calendars, Gantt    |    Writing VBA | Other

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:   VBA macros | General    |    Writing VBA | Other

Assigning short-cut keys to VBA macros in Excel

Posted by Andy Brown on 01 July 2011

This short blog shows how to assign short-cut keys to macros in Excel 2010, Excel 2007 and Excel 2003. So if you've written a whizzy macro in VBA and want to be able to run it with a single keystroke combination, read on!

Tags:   Writing VBA | VBA tutorial    |    Writing VBA | Other

Displaying the Developer Ribbon in Excel 2010

Posted by Andy Brown on 30 June 2011

This short blog shows how to display the Developer ribbon in Excel 2010 (it's different from Excel 2003 and Excel 2007!).

Tags:   Excel | General    |    Writing VBA | Other

Adding data labels to a chart using VBA

Posted by Andrew Gould on 08 June 2011

Adding basic data labels to a chart can be done without using any programming code. This blog, however, shows you how to fine-tune Excel chart labels using VBA (Visual Basic for Applications) macros.

Tags:   Excel | Charts    |    Writing VBA | Other    |    VBA macros | Working with charts
This page has 0 threads Add post