Hey all!
I'm trying to make a VB macro to count the number of times a digit (0-9) occurs in a column. An example is the number 873338 would give 3=3, 7=1, 8=2 all else = 0. Normally i would just use a countif function and avoid VB altogether, but I cant think of a way to break apart the larger number and sum the digit occurrences. Any help would be greatly appreciated!

Attached is my attempt using countif and 3 pieces of sample data.
numberCounter.xlsm