VBA Vlookup through 2 documents

[Spear86]

Hey Everyone,

I currently have a userform that pops open at this moment when my excel document opens but I am only wanting it to open if the people that are accessing it do not appear on another document list.

Currently This is how my code looks not put the vlookup into it but cannot work it out, can anyone help:

Please Login or Register  to view this content.

I am also trying to open the other file to sit in the background

[AlphaFrog]

This example uses the COUNTIF function to test if the value from twb.Sheets("Home").Range("A1") is found in nwb.Sheets("Accepted ID's").Range("A:A")

Please Login or Register  to view this content.

[Spear86]

Ah cheers for the input I finally figured out the code:

Please Login or Register  to view this content.

Thanks though