Years ago I conducted an Excel training session for Ohio Association for Institutional Research and Planning (OAIRP) and I used the following material for that Excel training: Exercise file for Excel training Excel Formulae Excel training handout
Continue readingIf you want to convert the text to uppercase, use the following code; however, I recommend downloading ASAP Utilities, it has many functionalities, including text conversion. It doesn’t offer source code though. Here’s my code for uppercase conversion:(If you want to convert your text to lowercase, replace Ucase with Lcase function in the code) ‘Will […]
Continue readingBooks on my shelf: Professional Excel Development by Stephen Bullen, Rob Bovey This is by far the most authoritative book on Excel development from Add-ins to APIs. A word of caution though, it is not for the beginners. Excel Advanced Report Development by Timothy Zapawa Ever wondered on using Excel as a report development tool? […]
Continue readingVery simple, uses the VBA function StrReverse to reverse the input string. ‘A function to reverse a string provided as input‘For example, the string “abcd” will become “dcba”‘Uses the VBA function StrReversePublic Function ReverseString(sInputString As String) As StringOn Error GoTo ReverseString_Error ReverseString = StrReverse(sInputString) Exit Function ReverseString_Error: ReverseString = “#ERROR#”End Function
Continue readingOh, man, I can’t tell how useful that concatenate function is. One repetitive use I found is to create OR/AND conditions for Access queries. I copy and paste the field values of a column from Access, do some filtering and my conditions are ready. Then I use this concat2 function to create a string to […]
Continue reading