Create a range with those items, say M1:Mn.

then add a dynamic range, InsertNameDefine Name with a name of say
ITProblems and a RefersTo value of

=OFFSET($M$1,,,COUNTA($M:$M),1)

then just use =ITProblems in the Data Validation List textbox.

You button should just add the value to the bottom of the range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"harpscardiff"
wrote in message
...

I got a basic spreadsheet, with validations. There is a cloumn with the
validation list, listing all common IT problems we experience -
Hardware, PC, Mice, Keyboard, printers.

I want an option at the bottom "Add New", once clicked it will allow
you to enter a new entry in the validation list.

Any ideas how I would do this?

Cheers
Harps


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=500111