How to use a global array correctly.

[Brad4444]

My code is as follows and then I will explain.

Please Login or Register  to view this content.

So basically I am trying to save lines of code by using For-Next loops and then working on this array. My problem appears in the second sub

Please Login or Register  to view this content.

It says Object required which I am assuming is because I have declared my array wrong. Can somebody confirm or deny this for me? You make something global by putting it outside the subs like the following...

Please Login or Register  to view this content.

Anyways any help is much appreciated. Thanks for your guys help.

[StephenR]

Not sure what you are doing. You assign strings to Description but then you go through and empty it. What are you trying to achieve?

[Brad4444]

I am attempting to create a user form where the person enters in each value (on the user form) and then read that data into the last row of an excel sheet.

[StephenR]

OK, I see now what you were trying to do. Can you post a workbook?

[Brad4444]

Sorry, I can't.

EDIT:

In the lines where the problem occurs

Please Login or Register  to view this content.

If I say Descriptions.Value would this call the text box value I am looking for? I guess I am asking "Am I calling the value syntactically correct?"

[MarvinP]

What happens if you use

Please Login or Register  to view this content.

?

[shg]

Is this supposed to clear controls?

Please Login or Register  to view this content.

If so, it should look something like this:

Please Login or Register  to view this content.

or maybe this:

Please Login or Register  to view this content.

In the first case, you are iterating through an array of controls. In the second, through an array of control names.

[Brad4444]

Sorry Shg, your code didn't help but it got me thinking.

Please Login or Register  to view this content.

What I want to do is assign a cell on a worksheet a value. I am storing strings in my array but they are just placeholders to call upon specific spots from my userform.

So what I need to know is where does the first element of an array in VBA begin? More importantly though... the code above gives me the error "type mismatch". Why? Once again thanks for all your guys help.

[shg]

(Many) Controls have a Value property, a Range has a Value property, Variants that represent objects have a Value property if the Object it represents does.

Variants used as ordinary variables (strings, numbers, ..., or arrays of same) do not.

Only Objects have Properties and Methods.

That was the point of my two examples.

[Brad4444]

Point taken now. The idea is working. Weird bug though that it offsets to far.