Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Is there a similar function in Word to data validation in Excel?
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? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Is there a similar function in Word to data validation in Excel?
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 "FinConBH" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
Word Field Codes in Excel data file | Mailmerge |