Wise Owl's Blog
Making Sense of Software

Excel | Microsoft training in London, UK

.NET / Programming blogs

Showing blogs 1-20 (out of 56)

Creating a website using CSS - a full worked example

Posted by Andy Brown on 16 May 2012 | no comments

Sometimes online training in style sheets isn't enough: you need a tutorial which takes you through the thought processes involved in creating styles for a web page, step by step.  This blog gives a full worked example (you may find it helpful first to look at the two previous parts of this CSS tutorial, on the principles of CSS and applying styles to HTML tags).

This blog is part of a larger online ASP.NET online training series.

Tags:   HTML and CSS / CSS

How to create styles for HTML tags using CSS

Posted by Andy Brown on 16 May 2012 | no comments

This is the second of a three-part online training series of blogs on CSS style sheets.  This blog shows how to create styles for specific HTML tags (the first part covers the principles of CSS style sheets, and the third part gives a worked example of CSS).

This blog is part of a larger online ASP.NET online training series.

Tags:   HTML and CSS / HTML   |   HTML and CSS / CSS

Creating CSS cascading style sheets for HTML

Posted by Andy Brown on 16 May 2012 | no comments

This is the first of a series of 3 tutorials showing how to create and use CSS style sheets for HTML web pages.  This first part explains how CSS works, a second part shows how to create styles for HTML tags and a final part gives a full worked example of creating a style sheet.

This blog is part of a larger online ASP.NET online training series.

Tags:   HTML and CSS / HTML   |   HTML and CSS / CSS

Createing master pages, CSS, skins and themes

Posted by Andy Brown on 01 May 2012 | no comments
How to create the perfect ASP.NET website, including using master pages, CSS style sheets, and whether to use skins and themes or not.

This blog is part of a larger online tutorial in ASP.NET.

Tags:   ASP.NET / Master pages   |   ASP.NET / Themes, skins, CSS   |   ASP.NET / General

Tutorial - creating the perfect ASP.NET website

Posted by Andy Brown on 24 April 2012 | no comments
This free online tutorial shows how to create the perfect website using ASP.NET using Visual Basic or Visual C#, user controls, styles, master pages, gridviews, data classes and stored procedures.

Finding missing WPF controls in the Toolbox

Posted by Andy Brown on 23 March 2012 | no comments
Sometimes the tool you need for a window isn't in the All WPF tools section of the toolbox - here's how to add it.
Tags:   WPF / General

Windows Forms or WPF ? Choosing software.

Posted by Andy Brown on 23 March 2012 | no comments
If you're developing software, should you use old-fashioned but reliable WinForms, or the exciting new concept, WPF?
Tags:   WPF / General   |   Windows Forms / General

Why VB trumps C#, and how trolls don't agree!

Posted by Andy Brown on 15 March 2012 | 2 comments
I recently wrote a blog on why (I believe) VB is a better programming language than C# - I wasn't prepared for the flames this would unleash.

Capture Excel application events - event sinks

Posted by Andy Brown on 06 March 2012 | 1 comment

It's not for the faint-hearted, but there is a way to capture application events (such as someone trying to create a new workbook) in Excel, using something called an event sink.  This blog explains how you might go about creating an event sink.

This blog is part of our Excel VBA training blog.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

How to Delete Digital Certificates from your Computer

Posted by Andrew Gould on 06 March 2012 | no comments
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.

Collections of class object using Excel VBA

Posted by Andy Brown on 05 March 2012 | no comments
If you've learnt how to create your own objects using classes in Excel VBA, the next step is to learn how to group them together into collections. This on-line tutorial will show you how.

This blog is part of our Excel VBA training blog.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

Creating classes in VBA - class modules

Posted by Andy Brown on 05 March 2012 | no comments

Those who want to add spice to their VBA programming can learn how to create classes, or class modules, and become object-orientated programmers.  It's difficult, but fun - and this multi-part blog will guide you along the way.

This blog is part of our Excel VBA training blog.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Classes

Using Excel Add-Ins to Share VBA Code

Posted by Andy Brown on 05 March 2012 | no comments

If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.

This blog is part of our Excel VBA training blog.

Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Advanced controls in userforms with VBA macros

Posted by Andy Brown on 28 February 2012 | no comments

The two previous parts of this mini-blog have shown how to draw forms and how to write code to handle form events.  This final part shows how to add some of the more exotic controls to user forms, like combo boxes, list boxes, multipage controls, spinners and option buttons.

This blog is part of our Excel VBA training blog.

Tags:   Excel / Excel Visual Basic   |   VBA macros / User forms

Writing VBA macros to work with user forms

Posted by Andy Brown on 28 February 2012 | no comments

The previous part of this three-part series showed how to draw user forms; this part shows how to write macros to get them to work (the final part shows how to use some of the more advanced controls, such as combo boxes and MultiPages).

This blog is part of our Excel VBA training blog.

Tags:   Excel / Excel Visual Basic   |   VBA macros / User forms

Drawing UserForms in the VBA code editor

Posted by Andy Brown on 28 February 2012 | no comments
Learn how to create your own custom dialog boxes in VBA, using UserForms.  This is the first part of a three-part series (the other parts are on Writing Code for UserForms and Creating Advanced Controls).

This blog is part of our Excel VBA training blog.

Tags:   Excel / Excel Visual Basic   |   VBA macros / User forms

Writing functions for Excel using VBA

Posted by Andy Brown on 24 February 2012 | no comments
On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.

This blog is part of our Excel VBA training blog.

Tags:   Excel / Excel Visual Basic   |   VBA macros / Functions

Arrays in Visual Basic for Applications macros

Posted by Andy Brown on 24 February 2012 | no comments
You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.

This blog is part of our Excel VBA training blog.

Using enumerations in VBA

Posted by Andy Brown on 24 February 2012 | no comments
Excel and other MS Office applications make extensive use of enumerations - and you should too!

This blog is part of our Excel VBA training blog.

Writing recursive programs in VBA

Posted by Andy Brown on 20 February 2012 | no comments
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.

This blog is part of our Excel VBA training series of blogs.

1-20   21-40   41-56