a good site for learning to create an interface (user form) is: http://www.techotopia.com/index.php/Visual_Basic_Essentials

for excel vb programming try using the macro recorder included in excel and the VB editor (press Alt+F11 inside excel and chose your module after recording to see how the code works) combine this with if, for, do until and do while loops (included in the course link above) to create excel add ins plus more.