Using IF function and a VLOOKUP in VBA - Basic uses

Hello all,

I am not a great VB programmer (my background is in C), and I cnanot get my VB code to look at a cell and return false if it has no contents and true otherwise.

Also I want it to check the cell on a different tab, what is the most efficient way of doing this without ".select"ing everything?

Cheers

p.s. Can you use the VLOOKUP excel funtion within your VBA code?

Hello ste_mulv,

Difficult to answer when your question is ambiguous. Is this "If" statement a worksheet function or a VBA statement? What does VLookup have to do with the "If" statement? You should your show code for clarification.

Something like:

Please Login or Register  to view this content.

Yes, you can also use VLOOKUP in VBA.

Please Login or Register  to view this content.

Hope this will help you do what you need to.

Please Login or Register  to view this content.

One can use the vlookup function in VB code.

I showed 2 different methods to check the cell contents. Don't know which would be most matches what you need.

You can reference cells without selecting them just by giving their address.
I'm new to VB, so my answers may not be semantically correct.