Hi All,

New to VBA programming (learning from a book), I'm progressing well
and am actually really enjoying the learning but have a couple of
questions:

The book I am using is pretty good, but the bit on Dim statements is
confusing me a bit and to make things worse I actually managed to
leave it at home today... I've gone headfirst into developing a
userform and I'm not sure just what the quickest/ easiest way is to
name all the variables (and, if I'm honest, just what the variables
are). Questions as follows:

My userform has a plenty of DatePickers, TextBoxes, ComboBoxes etc in,
would each of these be classed as a variable? If not then what is?!
Would these be appropriate: DatePickers as Date, ComboBoxes as String
and TextBoxes (if containing numbers) as Integer?
Where do I put the Dim statements, do they need to go at the start of
each Sub or is it just under Userform or is it in a separate module??

Also, I'm just wondering, can I use IF statements within a MsgBox and
if so how? I want the MsgBox to display slightly different things
depending on the value of a ComboBox, do I need a separate MsgBox for
each choice in the MsgBox or is there some clever way of doing it?

As you can see I am just starting up and would really appreciate any
help.

Thanks

Simon