Turn on the macro recorder and implement the feature manually. Then turn
off the macro recorder and generalize the recorded code if necessary.

--
Regards,
Tom Ogilvy


"simonchia" wrote in message
...

how can i programmatically generate the excel file which validate text
entries? i'm usign vb script to generate the excel file.


--
simonchia
------------------------------------------------------------------------
simonchia's Profile:
http://www.excelforum.com/member.php...o&userid=15813
View this thread: http://www.excelforum.com/showthread...hreadid=273103