Thread: How to add validation by VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michelle_ho michelle_ho is offline
external usenet poster
  
Posts: 1
Default How to add validation by VBA
I want to set validation of a cell from a list of value in another exce
file. I know that I can do from Data Menu - Validation. However,
want to do it by writing VBA code.

Example:
In A.xls, cell A1 = Apple
cell A2 = Orange
cell A3 = Pear
cell A4 = Banana

Then in B.xls, I want to set cell D3 can have the value only from th
above list,

How can I do so?

Thx a lot

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote