View original (French)

[VBA Excel] si variable = vide alors...

Solved
Fritz -  
fiddy Posted messages 441 Registration date   Status Contributor Last intervention   -
Hello,
I am working on a VBA program with a table containing references and I would like to search for a reference in this table.
However, the reference given is not necessarily in the table.

So, I created a text box to input the reference from the keyboard, and a search box with a variable.range function to find the reference in the table.

So far, so good.

After that, I want to have a variable if the reference is in the table then this happens...
and
else if the reference is not in the table then something else happens...

But I get error 91 when I don't have the same reference in the table, error = variable.range is empty.

I would like to know if we can write if variable = empty, because I don’t know how to do it. (I tried ="" and <>"")

Or if another solution exists other than searching.

Thank you.

3 answers

  1. Anonymous user
     
    Hello,

    Typical example: 

     Option Explicit Sub Test() Dim Value As Variant Value = ActiveCell.Value If (IsEmpty(Value)) Then MsgBox "Empty" Else MsgBox "Not Empty" End If End Sub

    Lupin
    7
  2. deepsoul94
     
    yet his answer was perfectly correct. Using IsEmpty is defensible.
    For clarity, IsEmpty(value) returns true if value is empty, false otherwise.
    1
    1. fiddy Posted messages 441 Registration date   Status Contributor Last intervention   1 847
       
      The position is 4 years old :/.
      Moreover, IsEmpty and Is Nothing do not serve the same purpose.
      0
  3. Fritz
     
    Lupin.A's solution didn't really help me, but thanks anyway.

    Actually, all I needed to write was:
    If variable is Nothing then

    and not:
    If variable = nothing then.
    0