Is there a similar function in Word to data validation in Excel?

F

FinConBH

I want to set up a table in Word and restrict entry for some columns to a
range of options. In Excel, I would have used the Data Validation option - is
there something similar available in Word?
 
D

Doug Robbins - Word MVP

If you were entering the data into formfields as in a protected document,
you could run a macro on exit from the formfield that use the visual basic
IsDate() function to validate the entry.

If you are not using formfields, you would have to manually invoke the macro
when the selection was in the cell into which the data was entered. You
could of course have it iterate through a range of cells in the columns
providing you define the range properly.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top