Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba excel - Combo box question - erasing value
Hi all, I have a combo box full of data. One of the data is "<New Item". want to locate, and erase that value from the list. I am trying the code below, but getting sintax error. Can anybody help? Thanks in advance, Aldo. For c1 = 0 To ComboBox.ListCount If ComboBox.Value(c1) = "<New Item" Then ComboBox(c1).clear exit for End If Next c -- ajliak ----------------------------------------------------------------------- ajliaks's Profile: http://www.excelforum.com/member.php...nfo&userid=819 View this thread: http://www.excelforum.com/showthread.php?threadid=27450 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Erasing Recent Documents History on Excel | Excel Discussion (Misc queries) | |||
Erasing a excel file | Excel Discussion (Misc queries) | |||
Erasing Outlook Calendar from within Excel | Excel Discussion (Misc queries) | |||
eXceL 2003 - list or combo box question | Excel Discussion (Misc queries) | |||
Excel 2000: Combo box cell link protection question | Excel Programming |