LinkBack URL
About LinkBacks
Is there any command by which we can close the dropdown list.
combobox.dropdown shows the list . I want a command to close the list.
Is there any command by which we can close the dropdown list.
combobox.dropdown shows the list . I want a command to close the list.
Once a Combo Box loses it's focus the list is not shown.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
How do i remove focus from combobox . My combobox is hidden and its dropdown is linked to a SHAPE . If i click on the shape dropdown list appears but when i click it again it doesnt disappear.
I suggest you attach your anonimized file,
Basically what i want to do is i want to apply filter in col A and i only want to display filter options not sorting options likes a to z , z to a . So i have used a shape and combobox , when i click shape combobox drops i want it to close like more filter if i click on it again .
Any other suggestions are welcomed.
When I click the arrow I can select a value then the combobox closes
I click it again it shows the list if i click elseweher it coses, what is it you're asking?
You want the autofilter without the extra stuff?
Is there a way to modify inbuilt autofilter function? TO remove the extra stuff , increase font size and show only check boxes? What i meant was if i click shape (arrow) dropdown list appears but without selecting a option if i click it again i want list to disappear (same way as it works in autofilter).
Im using excel 2007 it doesnt close if i click elsewhere .
Attachment 666493 i switch my focus to D6 still it wont close
I noticed that. I think the approach should be an entirely different one.
I also looked around (Google and more) and saw that unlike the context menus for the cells in a worksheet there is no way of changing the context menus in an AutoFilter.
The things is what do you want to do? what is the purpose? I don't want to assume what you want and go up the wrong way.
Knowing more about what you want will give me the hint which way to take it from there
Nothing specific just want to make the FONT bigger and dont want user to sort ( I can turn off sorting using vba though). Actually I dont want that unnecessary upper part of the autofilter menu which i wont be using anyways.
Okay, will put something simple together, got an idea, but it's past midnight here
Hope to find the time sometime during the day
Thank you SIR
This is what I came up with
I did not add any comments just the code and my idea
Works fine but coding is complicated for me as I am newbee
Well, now is your chance to learn.
VBA is not that difficult, it's common logic and loads of imagination
Corrected ti a little now you can add new values in column A and it updates automatically
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks