<div>
It worked!! &nbsp;Thanks... but if some reason I could not use Ln1? &nbsp;I made the procedure stop at places were I was setting a variable to Y or X... &nbsp;different one.. &nbsp;After I commented that out it worked. &nbsp;Any thoughts on the Ln 1
</div>


It worked!!  Thanks... but if some reason I could not use Ln1?  I made the procedure stop at places were I was setting a variable to Y or X...  different one..  After I commented that out it worked.  Any thoughts on the Ln 1

<div>
RWayneH<br />
<br />
You should always use Option Explicit as it helps you find undeclared variables, and you should always declare your variables.:)
</div>


RWayneH

You should always use Option Explicit as it helps you find undeclared variables, and you should always declare your variables.:)

<div>
^ What imnorie said. &nbsp; &nbsp;If you add the Option Explicit and then do a compile (VBA menu: Debug - Compile VBA Project) you'll be alerted to any/all undeclared variables.<br />
<br />
-Glenn
</div>


^ What imnorie said.    If you add the Option Explicit and then do a compile (VBA menu: Debug - Compile VBA Project) you'll be alerted to any/all undeclared variables.

-Glenn

<div>
<div class="content wysiwyg-content">
I use the code below to determine a value, however later in the procedure I would like to use it again and the value is empty? &nbsp;Is there a way to make this a global value so it is not lost? &nbsp;Or a way to carry the value from one procedure to another? &nbsp;Trying to determine just where I am losing it.<br />
<br />
session.findById(&quot;wnd[0]/u<wbr />sr/ctxtRMM<wbr />G1-MATNR&quot;)<wbr />.Text = strValidMatlNum
</div>
</div>


I use the code below to determine a value, however later in the procedure I would like to use it again and the value is empty?  Is there a way to make this a global value so it is not lost?  Or a way to carry the value from one procedure to another?  Trying to determine just where I am losing it.

session.findById("wnd[0]/usr/ctxtRMMG1-MATNR").Text = strValidMatlNum

Retaining a value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.