VBA If Isnull

[IanT]

Hi

I am using this code:

If IsNull((Range("ColA")(txtRow.Text).Value)) = False Then
txtColA.Text = Range("ColA")(txtRow.Text).Value
End If

to pull data from a cell to a text box on a userform but it still errors if there is a null value in the cell. Has anyone any ideas why!

 

[shades]

Howdy. Is this correct?

(Range("ColA")(txtRow.Text).Value)

________
Ordinary Life Insurance Forums

 

[IanT]

VBA If isnull

Hi

Yes... if there is a value in the cell it works fine.

 

[unmarkedhelicopter]

I think your syntax is a little screwed ...
What do you mean by Range("ColA")(txtRow.Text).Value ?