ParamArray Problem

[mafaisal]

Hello Experts

See My Code

Private sub F_Clear(Paramarray Cntr())
dim i%
For i=0 to ubound(cntr)
  cntr(i).text = ""
next
End sub

In this procedure when I call this error is coming
Any Bugs in the code
Error is

F_Clear (TxtBox(0),TxtBox(2))
Compile Error
Expected: =

[kadghar]

Hello Experts

See My Code

Private sub F_Clear(Paramarray Cntr())
dim i%
For i=0 to ubound(cntr)
cntr(i).text = ""
next
End sub


F_Clear (TxtBox(0),TxtBox(2))
Compile Error
Expected: =

I dont know what the problem might be. I tried it using two textboxes, and it cleared them without any problem. May be your textboxes have some issues.

btw, i liked your avatar.

HTH

[mafaisal]

Hello Kadghar
Thanx For Reply
Hw u try
Plz Give me
textboxe have wat pblm occure, if it is one then no prob

also Give u r trying code

I will

Faisal

I dont know what the problem might be. I tried it using two textboxes, and it cleared them without any problem. May be your textboxes have some issues.

btw, i liked your avatar.

HTH

[kadghar]

Hello Kadghar
Thanx For Reply
Hw u try
Plz Give me
textboxe have wat pblm occure, if it is one then no prob

also Give u r trying code

I will

Faisal

i created a new form with two textboxes : textbox1 and textbox2, then i copy pasted your sub, and in the click event of the form i called it:

Private Sub F_Clear(ParamArray Cntr())
Dim i%
For i = 0 To UBound(Cntr)
Cntr(i).Text = ""
Next
End Sub
 
Private Sub UserForm_Click()
Call F_Clear(TextBox1, TextBox2)
End Sub

then i run it, write something in each textbox and when i click on the form it clears both textboxes.

HTH

[mafaisal]

Hello Kadghar

Thanx For

It is wat is Usage of Using call Before Procedure

I mean
Call F_Clear(textbox1)

i just Call as
F_Clear(textbox1)

When use call Bfore that it working

Reply if u can

Faisal

i created a new form with two textboxes : textbox1 and textbox2, then i copy pasted your sub, and in the click event of the form i called it:

Private Sub F_Clear(ParamArray Cntr())
Dim i%
For i = 0 To UBound(Cntr)
Cntr(i).Text = ""
Next
End Sub
 
Private Sub UserForm_Click()
Call F_Clear(TextBox1, TextBox2)
End Sub

then i run it, write something in each textbox and when i click on the form it clears both textboxes.

HTH

[werks]

Hi guy'z the only thing differ between kadghar codes and mafaisal codes is that

kadghar

Call F_Clear(TextBox1, TextBox2)

mfaisal

F_Clear (TxtBox(0),TxtBox(2))

--
Kenneth
"Better Than Yesterday"

[mafaisal]

Hello

Yes I Know, When Use Call that work
My Question is Wat is the importants of Using Call...?

Faisal

Hi guy'z the only thing differ between kadghar codes and mafaisal codes is that

kadghar

Call F_Clear(TextBox1, TextBox2)

mfaisal

F_Clear (TxtBox(0),TxtBox(2))

--
Kenneth
"Better Than Yesterday"

[kadghar]

Hello

Yes I Know, When Use Call that work
My Question is Wat is the importants of Using Call...?

Faisal

I dont know. I thought it was the same using it or not.
I have that "bad habit" of using it, but... seems that it solved the problem this time.

There was a short discussion in this forum about using Call a few weeks ago, i'll see if i find it to ask why this is happening to some Expert...

Ô_o (wait... )

[werks]

This might help you

Importance of Call


--
Kenneth
"Better Than Yesterday"

[kadghar]

This might help you

Importance of Call


--
Kenneth
"Better Than Yesterday"

I see... but they say you can use it for calling functions if you dont care about the return value. but... this is not a function!!!!

=( this time i have no idea why this is happening, i'll google some similar situations.

[mafaisal]

K, Thanx
So It Concluded That
Using of Call is Good Practice
Usually i did not use Call
K

Faisal

This might help you

Importance of Call


--
Kenneth
"Better Than Yesterday"

[werks]

K, Thanx
So It Concluded That
Using of Call is Good Practice
Usually i did not use Call
K

Faisal

Yes! it is easier to identify codes.. you should start practicing it

[Killer42]

I've never used a ParamArray, so this might be incorrect. But my immediate response is that instead of
F_Clear (TxtBox(0),TxtBox(2))
you should try
F_Clear TxtBox(0), TxtBox(2)

[Killer42]

Yes! it is easier to identify codes.. you should start practicing it

Absolute rubbish! With the possible exception of a ParamArray (don't know yet) there's no reason to use Call.

EDIT: No, I've tried it, and the ParamArray has no effect. You don't need the Call either way. Just leave off the extra parentheses.

[kadghar]

I've never used a ParamArray, so this might be incorrect. But my immediate response is that instead of
F_Clear (TxtBox(0),TxtBox(2))
you should try
F_Clear TxtBox(0), TxtBox(2)

Not incorrect at all, it worked great.