Is it possible to have an ActiveX List Box run this formula?
=OFFSET($AI$23,MATCH($I$18,$AH$23:$AH$274,0)-1,0,COUNTIF($AH$23:$AH$274,$I$18),1)
I'm getting old and need the bigger font plus the searchab;e feature really speeds things up.
Thank you for any help!!
Sick
Last edited by sick stigma; 12-15-2011 at 11:55 AM. Reason: solved
Hello sick stigma,
If you use the formula to define a dynamic Named Range then you can assign it the ListFillRange property of the ListBox. For example, say you create a named range in column "A" called widgets and assign the formula above to it. You would set the ListBox's ListFillRange property like this...
ListBox1.ListFillRange = "Widgets"
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks