Excel 2003 vs Excel 2007 VBA

[forest8]

Hello

I need to create a data entry form but I currently use Excel 2003 but the
intended users have Excel 2007.

I also need to create a form in which it actually looks like the paper
version with labels and multiple type of data to be entered: dates, text,
check boxes, drop down menus.

Is there a good source for me to use?

Thanks
Forest

 

[Jacob Skaria]

A great place to start

http://www.contextures.com/xlUserForm01.html

Dont worry about the version. The userform will work with 2007.

If this post helps click Yes

 

[Dave Peterson]

If you're using an actual userform in the VBE, ignore this.

But if you're trying to use a worksheet as that form, then look at Debra
Dalgleish's site:

http://contextures.com/xlForm02.html
http://contextures.com/xlForm03.html
http://contextures.com/xlDataVal01.html