Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2020, 07:28 PM
BobBridges's Avatar
BobBridges BobBridges is offline Exists function for Collections as for Dictionary objects Windows 7 64bit Exists function for Collections as for Dictionary objects Office 2010 32bit
Expert
Exists function for Collections as for Dictionary objects
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default Exists function for Collections as for Dictionary objects

Long ago I chafed over the lack of an Exists method in VBA for collections. The Dictionary object has that method and it's very useful; it seems reasonable to me that there should be one for collections too. But apparently not.




So I've written an Exists function, and I'm pretty happy with it. But it occurred to me this evening to wonder whether I'm doing things the hard way. I can't be the only person who came up with a way to ask "Does such-and-such a collection have such-and-such a member?". What are the solution(s) y'all have come up with? Maybe you have something I should try out.


(I'm perfectly willing to share my solution, too, if anyone's interested. I'm not assuming anyone is, though :-).)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exists function for Collections as for Dictionary objects Verify if a datasource fieldname exists eduzs Word VBA 2 04-13-2018 03:20 AM
Exists function for Collections as for Dictionary objects Normal file already exists cryptogram Word 2 09-21-2015 08:56 PM
Exists function for Collections as for Dictionary objects Macros to move objects prevents moving same objects with arrow keys BruceM Word VBA 1 03-10-2015 08:20 AM
User exists but not account dbsoccer Windows 0 07-12-2014 04:18 PM
Exists function for Collections as for Dictionary objects Convert equation objects to inline objects sumjoh Word VBA 1 01-29-2013 08:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft