Hi,
I need a code which removes a particular value from the Drop Down (Form Control) using VBA.
Actually the condition is when the Drop Drown fill first time there is a value which is "Select Value" in the first
position
Whenever a user select any value from the Drop Down then this value should be Removed so the user can not select this
value again.
And after removing this value the index should be Reindex.
It will a great help for me
Thanx in Advance.
:o
Last edited by LalitPandey87; 10-06-2011 at 07:41 AM.
Code:Worksheets("Sheet1").DropDowns("NameOfDropDown").RemoveItem 1
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanx for giving me ur time from ur busy schedule.
I applied this but its not working for me. I don't know what i am doing wrong.
Have you changed the sheet name and dropdown name as required?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Yaa,
but it gives some error. and this command which you wrote is for Form Control(does'nt mean that i am creating user forms i placed the control in a sheet)
I really need it
Thanx.
I have used the same code in the attachment
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Its Gives me
Run-Time Error '1004'
RemoveItem method of DropDown class failed
Error when i am writing the same in my excel file.
I am filling this List Box by a namedrange.
You cannot have the listfill range and expect to remove an item from the list!! Instead of having the listfill through a range, why don't you add each item. Then you will also be able to remove item
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Yup Now its working.....
Thanx
Posting Permissions
Reply With Quote
Bookmarks