We have a help desk ticket system server down these days.

So I'll create a temporary simple data entry form in Excel sheet for
the temporary use.

The form has text fields, dropdown box,check box.

How can I create this, I don;t want to write any code if possible.

Or where can I find instructions to do these?

Thanks


--
xcao
------------------------------------------------------------------------
xcao's Profile: http://www.excelforum.com/member.php...o&userid=14538
View this thread: http://www.excelforum.com/showthread...hreadid=381870

check:

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

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381870

Look at this site:

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

If you browse around this site you'll see the other things you're asking
about.

Thanks, because I would enter data one record in a row, so I need the
combo box in every row, How can I do that? shall I just copy and paste
or is there any other way to do that so many rows can have that combo
box. Thanks


--
xcao
------------------------------------------------------------------------
xcao's Profile: http://www.excelforum.com/member.php...o&userid=14538
View this thread: http://www.excelforum.com/showthread...hreadid=381870

Do the following step-by-step.

1. Enter all the years, months and days in 3 columns outside the area
of the sheet you are using. Lets say these are columns AA, AB, and AC.
In AA1 to the number of years you want, enter the years. lets say
starting 1990 in AA1, 1991 in AA2, and so on. In AB1 enter Jan, AB2 Feb
and so on till Dec (enter as shown). In Ac1 enter 1, AC2 enter 2, till
31.

2. Select cell A1. Go to Data Validation. select list and in the
source, select the range AA1:AA10 (AA10 considering 10 years. Change
this to the total range you have).

3. Select cell B1. Data Validation. select list and enter source
AB1:AB12.

4. Select cell C1. Data Validation. Select list and enter the following
formula in the source:
=$AC$1:OFFSET($AC$1,DAY(DATE(A1,MONTH(DATEVALUE("1-"&B1&"-"&A1))+1,1)-1)-1,0)

5. In cell D1, enter formula:
=DATE(A1,MONTH(DATEVALUE("1-"&B1&"-"&A1)),C1)

So now you are ready to select the date through columns A, B and C. And
the date is generated in column D. You can simply copy the values down
to any number of rows in columns A, B, C, and D.

You may hide the column D if required, but still use it further for any
calculations.



Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381870