These days dynamic arrays, power query and DAX seem to be all the rage. But let’s not forget about an old friend: VBA UDFs (User Defined Function). Continue reading
Learn VBA UDF
Posts Tagged → udf
Video 00171 Create Christmas Lights Using Excel Sheets
Did you know that an Excel UDF can change the color of a sheet tab? David Hager’s post shows us how to do this! Somehow I came up with the idea to create Christmas Lights using Excel sheet tabs! Continue reading