I was having a play around with excel 2007 VBA and was hoping to create a Macro that generates a random number, then outputs a string based on the number generated. For example, 

Number String
1 A
2 B
3 C 
4 D

If the random number is 4, the output would be D. 

I have a table of a similar nature in my Excel worksheet. 

So far I have not had much success at doing this, any thoughts?