Creating a form

[mohitmahajan]

Hi,

Pls guide how can I create a data entry box without using VB, also th
data should get collected in a database (an excel file, as I can no
use access) and I also want to create an MIS out of the dat
collected.

Is this possible without using VB?

What is script editor, I know it is outside my league but extra inf
does not hurt, eh!!

 

[Harald Staff]

Hi

In an empty sheet:
Cell A1: "Name" (without quotes)
Cell B1: "City" (without quotes)
Cell C1: "Phone" (without quotes)

Format them centered bold. Now go to A2 and click menu Data > Form. OK if
Excel asks about headers -and there's your entry form.

HTH. Best wishes Harald

 

[mohitmahajan]

This is great.

Now the next step. Every time the sheet is opened, this form shoul
pop-up for the users. Also, automatic time capture should be there an
start time should be when the data is entered in the 1st field. En
time should come automatically when "new" is clicked. I want anothe
field where the difference of start and time should be capture
automatically.

Also, can I have some validations entered for each field?

I require your help in designing this without VB since VB is way abov
my head. :O

 

[Harald Staff]

That would require VB, sorry. You shouldn't refuse to use the best fit tool
to solve problems. Either learn it or hire someone to write this for you.

Best wishes Harald