This Access Excel tutorial explains how to use Scripting.Dictionary in VBA to store unique array item. You may also want to read: Access Excel VBA Array Remove duplicates in text using Dictionary Access Excel VBA Scripting.Dictionary to store unique array item An associative array, map, symbol table, or dictionary is an abstract data type composed of a collection of (key, value) pairs, such...

This Access Excel VBA tutorial demonstrates how to generate random HKID / Hong Kong ID card number. You may also want to read: Access Excel Function HKID Check Digit (last digit) Excel VBA Rnd Function to generate random number Excel generate random letter A to Z using RANDBETWEEN Assign unique random number using Excel Access Excel Generate random HKID  (Hong Kong ID card number) ...

This Excel tutorial explains how to generate random letter A to Z / a to z or a mix using RANDBETWEEN Function. You may also want to read Assign unique random number using Excel Use VBA to generate non-duplicated random number Excel generate random letter A to Z using RANDBETWEEN In order to generate random letter, we have to make use of two Functions. - RANDBETWEEN - CHAR In the...

This Excel tutorial shows how to make Excel timer countdown for test using Application.OnTime You may also want to read: Excel VBA Application.OnTime Method to schedule event with timer Send Email in Excel VBA using CDO and OLMailItem Excel timer countdown for test using Application.OnTime If you are going to job interview, you may be asked to do an Excel test. I have been thinking it w...

This tutorial explains how to use Excel Application.OnTime Method to trigger / schedule event at specified time. You may also want to read: Auto Open Excel with Windows Task Scheduler Excel automatically refresh pivot table Excel VBA Application.OnTime Method to trigger event at specified time You can do the followings with Excel VBA Application.OnTime Method - schedule a procedure t...

This Excel tutorial explains how to use the value above to fill blank rows (blank cells) in inactive Pivot Table in Tabular format. You may also want to read: Excel Delete Blank Rows Excel VBA reformat merged cells to row Fill Blank Rows or blank Cells Excel Pivot Table Fill Blank Rows In Pivot Table, when you group an item in column, the same grouping name does not repeat itself a...

This Excel tutorial explains how to ordinal data (text) in scatter chart using bar chart. Excel scatter chart using text name Excel scatter chart requires the x axis and y axis for each data point to be plotted in a diagram, and then join all those point together to analyze the trend or analyze if x and y variables are correlated, where X and Y values have to be numeric values. Below is an ex...

This Excel tutorial explains how to use Excel VBA to add Table AutoFilter, cancel Table AutoFilter, sorting Table. You may also want to read: Sort data using custom Function by Bubble Sort Sort data using custom Function by assigning number to Text Sort data using Range Sort Method Sort data using Worksheet AutoFilter Excel VBA Add Table AutoFilter or Cancel AutoFilter Using VBA...

This Excel tutorial explains how to use Excel VBA to add AutoFilter, cancel AutoFilter, add sorting in Worksheet AutoFilter. You may also want to read: Sort data using custom Function by Bubble Sort Sort data using custom Function by assigning number to Text Sort data using Range Sort Method Sort data using Table AutoFilter Excel VBA Add AutoFilter or Cancel AutoFilter Using VBA t...

This Excel tutorial explains how to use If condition on aggregate Function using Array such as Average, Median, Mean, Maximum, Minimum. Excel use If condition on aggregate Function using Array Some Excel formula require you to input a range cells as argument in order to calculate a value, such as Sum, Count, Average, Median, Mean, Maximum, Minimum. However, in those formula, you cannot use ...