LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Reset Combo Box back to Null


I have multiple combo boxes that have source cells that are all populated. However, I want to be able to reset all of the combo boxes back to Null (or even " "). Manually I can double click the contents of the list box (highlights) and then hit the delete key. How can I do this programmatically? Recording a macro does not capture this

Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reset workbook back to Auto Calculate Karl_S Excel Discussion (Misc queries) 8 April 17th 09 09:26 PM
reset value back to zero Mike[_3_] New Users to Excel 2 November 10th 07 04:57 PM
Sum brings back null Value RedDevil Excel Discussion (Misc queries) 2 April 2nd 07 11:47 AM
How do I reset my opening cell back to A1? sloowhand Excel Discussion (Misc queries) 1 February 28th 06 12:55 AM
Null value return from combo box zsplash Excel Programming 2 September 12th 03 11:49 PM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"