Removing the Selected Item in a ComboBox
Hello,
Im using dependent Combo Boxes in an Excel File. Im trying to figure out how to remove the selected item in one of the Combo Boxes.
Im using the .AddItem Function in the VBA Code to populate the Combo Boxes.
Ive tried .... comboBox1.Items.Remove(comboBox1.SelectedItem) .... but no luck.
I would be grateful for your help. Many Thanks
PT
Hello. An important question:
- How did you fill the comboBox?... With the powerful RowSource or with the inefficient AddItem?
You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.
If it was the second way I asked you for, then you can try:
PHP Code:Private Sub CommandButton1_Click()
Dim i&
With ComboBox1
i = .ListIndex
If i >= 0 Then .ListIndex = -1: .RemoveItem i
End With
End Sub
Hello,
I am filling the Combo Box with the AddItem function.
Unfortunately your code does not work.
do you want a permanent removal or only removed for the duration of your app.
upload your workbook for a concise solution.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Re: Removing the Selected Item in a ComboBox
Hello,
Yes, I want to permanently remove the item in the Food Item Combo Box.
This is what i wish to achieve:
1. Open the User Form
2. Click on the Food Type Combo Box and Select a Food Type, e.g Grains
3. This adds the items - Cereals, Bread, Pasta to the Food Item Combo Box
4. When I select Cereals it writes this to Cell C5.
(All of the above is working OK)
Now ... this is what I wish to do beyond this point
5. Remove Grains from the Food Item Combo Box when I return to it after selecting one of the other Food Types in the Food Type Combo Box.
Hope this makes sense and that the attachment has been included in this message!
Thank you.Example_Two Dependent Combo Boxes on UserForm.xlsm
The suggested works perfectly.Originally Posted by MacroPete
What happens is that when you implement what is suggested, a recursive process starts that ends up giving you an error.
In fact: it would seem that what you should delete is the chosen element from ComboBox2 and not from ComboBox1: Do you want to think better?...
Analyze if the attached model is more like what you want to achieve:
Last edited by beyond Excel; 03-30-2023 at 12:04 PM.
Hello,
Yes indeed ... this works very well! Thank you.
I cant access the UserForm Code though. Could you send me a version of this file so that i can edit the code further?
Many thanks.
a) Do not forget to 'Click' on the * found in the lower-left part of post #8 to thank the proposal.
b) What do you do to enter the VBA environment?...
Hello beyond Excel,
Yes I have accessed the code now. It is all ok. Many thanks again for your help.
Again:
Do not forget to 'Click' on the * found in the lower-left part of post #8 to thank the proposal.
Hello,
I have clicked on the on the * and left a comment about the excellent help you gave me for this problem. Can you see the comment?
Thanks for that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks