Error Help ClearContents

[millwalll]

Hi I am geting a error but not too sure why this line of code ,


Software_form.txtSoftware1.Value = ClearContents

compile error
variable not defined

I understand the error but I thought clearContents was build in variable the
code is in form

any help many thanks

 

[NateBuckley]

If it's a list box then you can do the following

lstBoxTest.Clear

but when you use the = sign you are trying to assign something to the
object, so even if the textBox (I'm guessing that's what it is) did have a
clear function it would be used by calling a method within the object like so

Software_form.txtSoftware1.Clear but that won't work.
Just do

Software_form.txtSoftware1.Value = ""

 

[Tom Hutchins]

When I check the VBA help (Excel 2003), I only see a ClearContents method,
not a "built-in variable". The ClearContents method only applies to ranges
and charts. I suggest you set the value of your textbox to vbNullString to
clear it:

Software_form.txtSoftware1.Value = vbNullString

Hope this helps,

Hutch

 

[millwalll]

Thanks I will try that but what I dont get is it was working before !!