Hi All, Apologies but i am completely stumped on this one and all searches of the forums etc have turned up nothing. Anyway I am putting together a tracker that has a user interface to allow then to stick in some text, which will automatically find the corresponding values from a base data sheet and hence update an actual tracking worksheet.
However as i dont want to lose any new base data, then i want to check that the info inserted is already in the base data sheet and if not force them to add it so that it is there next time round. Now i was thinking off using something along the same lines as a VLookUp or find etc, however cannot find any help on how to actually use this to read the contents from a text box (in my user form) and return a yes/no, True/False etc that the base data sheet conatins the information already. Any help would be greatly appreciated. Andy -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
