Excel 2003 vs Excel 2007 VBA
 

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

Excel 2003 vs Excel 2007 VBA
 

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
---------------
Jacob Skaria


"forest8" wrote:

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

Excel 2003 vs Excel 2007 VBA
 

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


forest8 wrote:

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

--

Dave Peterson