| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Delete Drop Down, Retain Values
Group, Is it possible through VBA to delete a sheets drop-down lists, yet retain the value selected in the list? I think this is a toughy. Help for fledgling, wanna be VBA programmer would cap this weekend. Tony -- ajocius ------------------------------------------------------------------------ ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695 View this thread: http://www.excelforum.com/showthread...hreadid=391601 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA - Delete Drop Down, Retain Values
Hi Tony:
Try: ActiveSheet.UsedRange.Validation.Delete --- Regards, Norman "ajocius" wrote in message ... Group, Is it possible through VBA to delete a sheets drop-down lists, yet retain the value selected in the list? I think this is a toughy. Help for fledgling, wanna be VBA programmer would cap this weekend. Tony -- ajocius ------------------------------------------------------------------------ ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695 View this thread: http://www.excelforum.com/showthread...hreadid=391601 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove duplicates but retain one not delete both | Excel Discussion (Misc queries) | |||
| retain value and delete format | Excel Worksheet Functions | |||
| How to delete/change the formula of a cell and yet retain its cont | Excel Worksheet Functions | |||
| How delete formula bar and retain the computed number in a cell? | Excel Worksheet Functions | |||
| Data values WON'T DELETE in PivotTable drop-downs | Excel Discussion (Misc queries) | |||
![ajocius[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
