Data Entry Validation in Excel

  • Thread starter Thread starter svijay
  • Start date Start date
S

svijay

HI

Happy New year 2004 to all of you.

Im trying to incorporate data entry validation in excel sheet.Lik
restricting only numerics
or alphabets etc like how we do in VB form or in a web page using jav
script.

My requirement is the sheet is created dynamically and I need to acces
few cells and have
to assign data type to that cell so that user can enter valid values a
per the data type
assigned.

I searched in the Excel object model but Im unable to find assign dat
type to a cell or
range of cells.

So if any one of U know solution let me know.

Thanx in advance.

Cheers
Vija
 
Data validation options are found under the menu Data=>Validation.

Beyond that, no capability is provided.
 
Back
Top