Posts Tagged ‘VBA’

VBA Function to Show Cell Formula

Friday, October 24th, 2008 at 12:58 | 0 comments
Tags: ,

How to Create a Bar Chart using VBA

Wednesday, October 15th, 2008 at 02:15 | 2 comments
Categories: Charts, VBA
Tags: , ,

VBA: Highlight Duplicates in a Range

Monday, October 13th, 2008 at 14:05 | 3 comments

VBA: User Defined Function that Counts Selected Cells

Saturday, October 4th, 2008 at 10:51 | 0 comments

VBA: Calculate Acronyms from Strings

Saturday, October 4th, 2008 at 10:45 | 1 comment
Categories: Strings

VBA: UDF to perform a 3-parameter Vlookup

Saturday, October 4th, 2008 at 10:36 | 5 comments
Categories: LOOKUP, VBA

VBA: Excel’s Colour Scheme

Tuesday, September 30th, 2008 at 14:47 | 0 comments
Categories: VBA

VBA and Vlookup: Find occurence of string

Tuesday, September 30th, 2008 at 14:40 | 2 comments
Categories: LOOKUP, VBA

Interacting between VBA and Excel – Functions

Tuesday, September 30th, 2008 at 14:31 | 0 comments
Categories: Charts, VBA

VBA Function: Populating a Range

Friday, September 26th, 2008 at 11:06 | 2 comments