I have a userform that utilizes a named range in a worksheet named "Files" to display images in it (worksheet contains path and name of images) . The named range is used as the "RowSource" for the combobox (cmbImg). How do I set it up so that it only display visible cells? When I prefer an Autofilter, it still shows all images.
Code is below..
Please Login or Register to view this content.
You can't use RowSource for this application. You have to use the .AddItem method.
Put this code snippet in the Intialize event
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I am getting a "Run Time Error 438...Object doesn't support this property or method"..I changed the code to say. Unfortunately, it is not highlighting the line with the error. Any ideas? Thanks.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks