Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Clear Combobox

What is the quickest way to clear all entries in a combobox?

Thanks


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Clear Combobox

Try something like

Combobox1.Clear


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"King" wrote in message
news:aAAib.761784$uu5.132039@sccrnsc04...
What is the quickest way to clear all entries in a combobox?

Thanks




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Clear Combobox

Depends on how they got there. For rowsource

Combobox1.RowSource = ""

--
Regards,
Tom Ogilvy

"King" wrote in message
news:aAAib.761784$uu5.132039@sccrnsc04...
What is the quickest way to clear all entries in a combobox?

Thanks




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default Clear Combobox

This search provides a multitude of answers.

http://www.google.com/groups?as_q=Cl...n&num=50&hl=en

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

What is the quickest way to clear all entries in a combobox?

Thanks


Reply
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
Transfer a name from one cell to another but leave clear if clear? Scoober Excel Worksheet Functions 3 May 22nd 09 02:55 AM
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
clear the clear the web page email attachment lines MCrider Excel Discussion (Misc queries) 0 November 11th 07 10:05 PM
combobox changes value flow23 Excel Discussion (Misc queries) 0 May 11th 06 04:44 PM
Combobox M Excel Discussion (Misc queries) 1 March 7th 05 10:29 AM


All times are GMT +1. The time now is 06:00 AM.

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"