[ms office - 2007] Data input form referencing to table/cell titles (excel 2010)

[satz]

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)

 

 

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