Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting formula in data validation list
Could anyone help..?
I have a work sheet with data validation drop down list for user selection, i also have a formula in the same cell were data is sometimes inserted without the user having to make a selection from the list, this is fine, users can and need to insert other data which is not in the drop down list, no problem here.. Is there any way to allow this data to change or be deleted but still retain the formula, in the cell if the cell were blank? Any help would be appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting formula in data validation list
Hi, It would seem to me that formula has to match with whatever input ... Should your formula be deleted, an event macro could re-input it ... HTH Cheers Carim -- Carim ------------------------------------------------------------------------ Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259 View this thread: http://www.excelforum.com/showthread...hreadid=533190 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting formula in data validation list
Thanks Carim .. any help with creating the event macro..? codes and macros
i'm not too familiar with.. Cheers "Carim" wrote: Hi, It would seem to me that formula has to match with whatever input ... Should your formula be deleted, an event macro could re-input it ... HTH Cheers Carim -- Carim ------------------------------------------------------------------------ Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259 View this thread: http://www.excelforum.com/showthread...hreadid=533190 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
Expanding Data validation from List | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions |