You need a worksheet change event macro to monitor C1 and respond accordingly.

See:

http://www.mvps.org/dmcritchie/excel/event.htm

for complete details. Good Luck
--
Gary's Student


"xXx Katie xXx" wrote:

How can i use an IF statement to start a macro using data validation to get a
list in a cell if the previous cell equals a specific word.

Eg. IF C1 = "Bedroom" then it will trigger the macro to use data validation
in the next cell to display a list of diffent number of bedrooms which the
user can then choose.