ParamArray Problem

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

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

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:

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

HTH

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:

Expand|Select|Wrap|Line Numbers

1. Private Sub F_Clear(ParamArray Cntr())
2. Dim i%
3. For i = 0 To UBound(Cntr)
4. Cntr(i).Text = ""
5. Next
6. End Sub
7.  
8. Private Sub UserForm_Click()
9. Call F_Clear(TextBox1, TextBox2)
10. End Sub

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

HTH

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

kadghar
mfaisal

--
Kenneth
"Better Than Yesterday"

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

Expand|Select|Wrap|Line Numbers

1. Call F_Clear(TextBox1, TextBox2)

mfaisal

Expand|Select|Wrap|Line Numbers

1. F_Clear (TxtBox(0),TxtBox(2))

--
Kenneth
"Better Than Yesterday"

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... )

This might help you

Importance of Call


--
Kenneth
"Better Than Yesterday"

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.

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"

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

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)

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.

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.