Access Excel VBA Chr Function to convert ASCII value to character

Posted on February 9, 2015April 5, 2015 by Wyman W

This Access Excel VBA tutorial explains how to use Chr Function to convert ASCII value to character, and convert from character to ASCII value with ASC Function What is Access Excel VBA Chr Function? Access Excel VBA Chr Function converts ASCII value to a character. ASCII (American Standard Code for Information Interchange) uses 8-bit code units, an old encoding system which stores mainly numbers, lowercase letters a to z, uppercase letters A to Z, basic punctuation symbols, control codes. M...

Excel Char Function to convert ASCII value to character

Posted on February 9, 2015February 9, 2015 by Wyman W

What is Excel Char Function? Excel Char Function converts ASCII value to a character. ASCII (American Standard Code for Information Interchange) uses 8-bit code units, an old encoding system which stores mainly numbers, lowercase letters a to z, uppercase letters A to Z, basic punctuation symbols, control codes. Many old systems still use this encoding system. 8 bit means the computer memory uses “8” digits with 1 and 0 combination (binary) to represent a character, 8 bits memory is equal to ...

Excel VBA Msgbox and handling of return value

Posted on February 9, 2015August 22, 2015 by Wyman W

This Excel tutorial explains how to use Excel VBA Msgbox with carriage return such as vbCr, vbNewLine, and handling of return value such as vbOK, vbCancel, vbRetry You may also want to read: Excel VBA Inputbox and Application.Inputbox What is Excel VBA MsgBox? Excel VBA MsgBox is a prompt box that is used to prompt user for important information, usually provide user with OK and Cancel buttons. Note that there is another prompt box called InputBox which receives text input from user but ...

Access Excel VBA extract number from text or extract alphabet

Posted on February 8, 2015September 4, 2017 by Wyman W

This tutorial shows several Access Excel VBA custom functions to extract number from text, extract alphabet from text, extract symbols from text Excel Access VBA extract percentage from text Excel Extract Time from Date Time or Extract Date Access Excel extract file name from file path Access Excel VBA extract number from text or extract alphabet from text In this article, I will show a list of custom Functions to perform the following tasks. - Check if a text contains any alphabet, ...

Excel VBA ASC Function to get ASCII value of text

Posted on February 8, 2015April 13, 2015 by Wyman W

This page explains how to use Excel VBA ASCFunction to get ASCII value of a text, and how to check if a text contains an alphabet, number or symbol What is Excel VBA ASC Function? Excel VBA ASC Function returns the ASCII value of the first character in a text. ASCII (American Standard Code for Information Interchange) uses 8-bit code units, an old encoding system which stores mainly numbers, lowercase letters a to z, uppercase letters A to Z, basic punctuation symbols, control codes. Many ol...

Excel Code Function to get ASCII value of text

Posted on February 7, 2015October 24, 2017 by Wyman W

What is Excel Code Function? Excel Code Function returns the ASCII value of the first character in a text. ASCII (American Standard Code for Information Interchange) uses 8-bit code units, an old encoding system which stores mainly numbers, lowercase letters a to z, uppercase letters A to Z, basic punctuation symbols, control codes. Many old systems still use this encoding system. 8 bit means the computer memory uses “8” digits with 1 and 0 combination (binary) to represent a character, 8 bits ...

Excel VBA Extract columns to new workbook

Posted on February 7, 2015 by Wyman W

Excel VBA Extract columns to new workbook This was originally a question raised in Microsoft Community and was answered by me. I copied the original question below. I'm sure my issue is not unique. I have a excel document with hundreds of columns and only want about a dozen of them. I need to be able to extract specific columns to a new excel sheet as a repeated process without manual intervention. All I need is to pull certain columns into a new excel sheet from an excel document t...

Excel VBA Indentation and Auto Indent

Posted on February 7, 2015March 29, 2015 by Wyman W

What is Excel VBA Indentation? Indentation represents some spaces at the beginning of a new row of sentence. Indentation is not a word reserved for VBA, it is a word that also appears in Microsoft Word, Excel spreadsheet and even Powerpoint. Indentation is also used for all kinds of computer programming. In VBA coding, indentation is not mandatory, which means it does not cause compile error if you miss it, but it is definitely a good practice for you or for others to follow your code easily...

Excel VBA LEN Function to measure length of text

Posted on February 6, 2015December 18, 2016 by Wyman W

This Excel VBA tutorial explains how to use LEN Function to measure length of text. Excel VBA LEN Function Excel VBA LEN Function is to measure the length of text, to be more precise, the number of characters in a text. LEN Function is most useful as a tool for data validation where length of text always have limit in a system. LEN Function is also commonly used in conjunction with other functions: LEFT Function - extract a substring on the left RIGHT Function - extract a substri...

Excel LEN Function to measure length of text

Posted on February 6, 2015 by Wyman W

What does Excel LEN Function do? Excel LEN Function is to measure length of a text. Why do you need Excel LEN Function? Excel LEN Function is not quite meaningful to use alone, it is more of a stepping stone to achieve another purpose. LEN Function is most commonly used with the following functions in order to extract a substring from a string. LEFT Function - extract a substring on the left RIGHT Function - extract a substring on the right MID Function - extract a substring in the m...