Create a grouped frequency distribution using vba

Hi, I have a list of 225 numbers which I've grouped into 8 intervals from <30 to >=90 i need to create a frequency distribution out of this data. However, I'm not sure where to begin with the code that i need to write this. Then from this I would like to create a histogram. Any help would be much appreciated, thank you.