Developer

Murray Brown

1696400351192.png

<div>
<p>Great. Thankyou both very much. I suppose it goes without &nbsp; saying &nbsp; that &nbsp; it &nbsp; will &nbsp; worked &nbsp; once&nbsp; &nbsp;compiled</p>
</div>


<div>
<div class="content wysiwyg-content fr-view">
<p>Hi</p><p>In my <a target="_blank" rel="ugc nofollow">VB.net</a> Excel Add-in I am trying to find a value in a worksheet but even though I have a Try...Catch around the code it doesn't go to the Catch part but gets stuck &nbsp; on the find Part as shown in the &nbsp; image. Why would this be?</p><p><a href="https://filedb.experts-exchange.com/incoming/2023/10_w40/1625038/Image4.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2023/10_w40/1625038/Image4.png" class="fr-fic fr-dib"></a></p><p><br></p>
</div>
</div>


Image4.png


Hi
In my
VB.net
Excel Add-in I am trying to find a value in a worksheet but even though I have a Try...Catch around the code it doesn't go to the Catch part but gets stuck   on the find Part as shown in the   image. Why would this be?


Great. Thankyou both very much. I suppose it goes without   saying   that   it   will   worked   once   compiled

Excel VB.net code error on Find not handled By TryCatch


Hi
In my
VB.net
Excel Add-in I am trying to find a value in a worksheet but even though I have a Try...Catch around the code it doesn&#39;t go to the Catch part but gets stuck   on the find Part as shown in the   image. Why would this be?

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

Microsoft Excel

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.