Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing item from combobox with vba
Tom, The comboboxes are populated during the UserForm_Initialize() event: Private Sub UserForm_Initialize() With comTeam1 .AddItem "Airdrie" .AddItem "West Lothian" End With - (many more teams in the real sheet) With comTeam2 .AddItem "Airdrie" .AddItem "West Lothian" End With - (many more teams in the real sheet) End Sub So I felt that during the code I could use something like: "comTeam2.RemoveItem comTeam1" Thanks Seamu -- SO ----------------------------------------------------------------------- SOS's Profile: http://www.excelforum.com/member.php...nfo&userid=540 View this thread: http://www.excelforum.com/showthread.php?threadid=26314 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing item from combobox with vba
You can, but removeitem requires an index
comTeam2.RemoveItem comTeam1.ListIndex -- Regards, Tom Ogilvy "SOS" wrote in message ... Tom, The comboboxes are populated during the UserForm_Initialize() event: Private Sub UserForm_Initialize() With comTeam1 AddItem "Airdrie" AddItem "West Lothian" End With - (many more teams in the real sheet) With comTeam2 AddItem "Airdrie" AddItem "West Lothian" End With - (many more teams in the real sheet) End Sub So I felt that during the code I could use something like: "comTeam2.RemoveItem comTeam1" Thanks Seamus -- SOS ------------------------------------------------------------------------ SOS's Profile: http://www.excelforum.com/member.php...fo&userid=5406 View this thread: http://www.excelforum.com/showthread...hreadid=263147 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
item limit for a combobox? | Excel Worksheet Functions | |||
Removing item from combobox with vba | Excel Programming | |||
Remove item from combobox. | Excel Programming | |||
Disable item in combobox | Excel Programming | |||
ComboBox and select item | Excel Programming |