Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Question....Can this be done?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Question....Can this be done?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Question....Can this be done?
thanks for your reply - got most of your instructions, wasn't sure about the button?? I dont have a button, I was hoping, in the validation list, if i an option "add new", a prompt box could come up, you type it in and then it adds it into the list? -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=500111 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Data Validation question | Excel Discussion (Misc queries) | |||
Data validation question | New Users to Excel | |||
A new twist to the validation drop-down width question. | Excel Discussion (Misc queries) | |||
Validation Data & Goto question | Excel Discussion (Misc queries) | |||
Data Validation list selection question | Excel Worksheet Functions |