Hello All


I'm creating a small calendar in Excel and i was wondering whats the best way to input data in to my table.

So far my ideas to have a data input form where i select a name and enter my custom date with my custom text. My logic behind this on my form i select "Tom" from a a drop down, and then i insert the date "16/02/2012" and in my custom text box i would enter in something like SF which should populate cell E6 with SF. (see example below)

example.JPG

I've got very basic VBA skills which i did in collage way back but i don't putting some effort in to learning.