Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
FinConBH FinConBH is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word should catalog misspelled words to study. rndthought Microsoft Word Help 39 May 21st 23 02:47 AM
How to put graphics on envelopes? Steve Koenig Microsoft Word Help 21 April 29th 23 02:47 AM
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Difficulty pasting Excel data into Word table only in XP versions Digitonomy Tables 0 February 28th 05 12:33 AM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM


All times are GMT +1. The time now is 08:16 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"