<div>
Actually, you have it set as a variant array, which means you need to refer to the array dimensions in your second line. &nbsp;Arrays don't have a 'default' like controls do. <br />
<br />
varPlant(0,0) = description<br />
or<br />
varPlant(1,0) = description<br />
<br />
Hope this helps.<br />
-Jim
</div>


Actually, you have it set as a variant array, which means you need to refer to the array dimensions in your second line.  Arrays don't have a 'default' like controls do.

varPlant(0,0) = description
or
varPlant(1,0) = description

Hope this helps.
-Jim

<div>
Okay now I'm getting a variable not defined (it's pointing at the description) &nbsp;I shouldn't have this as a variable if I'm trying to get the plant description. &nbsp;Or am I making this more difficult?
</div>


Okay now I'm getting a variable not defined (it's pointing at the description)  I shouldn't have this as a variable if I'm trying to get the plant description.  Or am I making this more difficult?

<div>
You need to to what jimhorn said then, you need to define the variable description, and put something in it. Alternatively just put a literal straight into the variable.<br />
<br />
Something like <br />
...<br />
&nbsp; &nbsp; Dim description As String<br />
... &nbsp; <br />
<br />
&nbsp;description = &quot;My description&quot;<br />
...<br />
&nbsp; &nbsp; varPlant(0,0) = description<br />
&nbsp; &nbsp; 'or<br />
&nbsp; &nbsp; 'varPlant(1,0) = description<br />
<br />
OR<br />
<br />
&nbsp; &nbsp; varPlant(0,0) = &quot;My description&quot;<br />
&nbsp; &nbsp; or <br />
&nbsp; &nbsp; varPlant(1,0) = &quot;My description&quot;<br />
<br />

</div>


You need to to what jimhorn said then, you need to define the variable description, and put something in it. Alternatively just put a literal straight into the variable.

Something like
...
    Dim description As String
...  

 description = "My description"
...
    varPlant(0,0) = description
    'or
    'varPlant(1,0) = description

OR

    varPlant(0,0) = "My description"
    or
    varPlant(1,0) = "My description"



<div>
Thank you very much cleared up a lot. Thanks
</div>


Thank you very much cleared up a lot. Thanks

<div>
<div class="content wysiwyg-content">
I need to get the description name from varPlant which is set as a variant<br />
<br />
varPlant(1,0) as Variant<br />
varPlant = description<br />
This is what I have which is not correct. &nbsp;It may be easy to someone who knows VB but I'm new to this.
</div>
</div>


I need to get the description name from varPlant which is set as a variant

varPlant(1,0) as Variant
varPlant = description
This is what I have which is not correct.  It may be easy to someone who knows VB but I'm new to this.

how to get varPlant get description for plant code

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.