Writing Excel User Defined Functions in VBA – part #2 – time stamping, concatenating date and text while maintaining the date format

01/19/2011

Hi Folks, there are many available built-in spreadsheet functions in Excel. Ocasionaly one might need to write a special custom function. This second short tutorial is an introduction to that.  Creating a “Time Stamp” function is presented as a first example after which a concatenation function between a custom formatted date and a string (text) is introduced. This last function came about from a question I was asked by a finance person at…

Read More >>

Writing Excel User Defined Functions in VBA – part #1 – the distance function

01/14/2011

There are many available built-in spreadsheet functions in Excel. Ocasionaly one might need a very special custom function. This short tutorial is an introduction about how to write a user defined function which calculate the distance between two points in a cartesian plane. The topic will be continued and custom functions will occasionally be used in future models. We’d love to hear from you. [sociallocker][/sociallocker]

Read More >>