<div>
Hi PetEdge,<br />
<br />
Try this:<br />
<br />
Sub find()<br />
<br />
Application.Dialogs(xlDial<wbr />ogFormulaF<wbr />ind).Show<br />
<br />
End Sub<br />
<br />
Jim
</div>


<div>
Thanks Jim for the response. &nbsp;<br />
<br />
This does work in both versions of Excel but what I've now lost is the ability for the customer to leave the &quot;Find&quot; dialog box open while they update quantities on the order form. &nbsp;<br />
<br />
Are there any other commands/options that might return the functionality in my original code?<br />
<br />
Here's the strangest thing that maybe someone can address...<br />
<br />
If I execute my original code from the VB window in either version of Excel, the &quot;Find&quot; dialog box appears, it's only when I click the button I created in 2007 that doesn't bring up the pop-up in 2003. &nbsp;<br />
<br />
Thanks. 
</div>


<div>
So does your button's click event simply call the find sub then? What is that actual error message you get in 2003?<br />
Regards,<br />
Rory<br />

</div>


Excel-Find-Execute-Error.bmp

<div>
Or set the button's TakeFocusOnClick to False.
</div>


<div>
Thanks, Jim - I was being lazy! :)
</div>


<div>
<div class="content wysiwyg-content">
I have an ActiveX Command Button I created in an Excel 2007 spreadsheet to execute the &quot;Find&quot; function. &nbsp;The button will be used by customers to find a product on an order form. &nbsp;The problem is that the code tied to the button works great in Excel 2007 but gives an error message if you try clicking the button in 2003. &nbsp; &nbsp;<br />
<br />
How can I make it function in both versions ? <br />
<br />
Thanks in advance for any help.<br />

<pre><code id="code-315109">Sub find()
Application.CommandBars.FindControl(ID:=1849).Execute
End Sub
</code></pre>
</div>
</div>


I have an ActiveX Command Button I created in an Excel 2007 spreadsheet to execute the "Find" function.  The button will be used by customers to find a product on an order form.  The problem is that the code tied to the button works great in Excel 2007 but gives an error message if you try clicking the button in 2003.    

How can I make it function in both versions ? 

Thanks in advance for any help.

Hi PetEdge,

Try this:

Sub find()

Application.Dialogs(xlDialogFormulaFind).Show

End Sub

Jim

Thanks Jim for the response.  

This does work in both versions of Excel but what I&#39;ve now lost is the ability for the customer to leave the &quot;Find&quot; dialog box open while they update quantities on the order form.  

Are there any other commands/options that might return the functionality in my original code?

Here&#39;s the strangest thing that maybe someone can address...

If I execute my original code from the VB window in either version of Excel, the &quot;Find&quot; dialog box appears, it&#39;s only when I click the button I created in 2007 that doesn&#39;t bring up the pop-up in 2003.  

Thanks. 

So does your button&#39;s click event simply call the find sub then? What is that actual error message you get in 2003?
Regards,
Rory


Or set the button&#39;s TakeFocusOnClick to False.

ActiveX Control Button works in Excel 2007 but not Excel 2003

I have an ActiveX Command Button I created in an Excel 2007 spreadsheet to execute the &quot;Find&quot; function.  The button will be used by customers to find a product on an order form.  The problem is that the code tied to the button works great in Excel 2007 but gives an error message if you try clicking the button in 2003.    

How can I make it function in both versions ? 

Thanks in advance for any help.

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.

Visual Basic Classic

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

Web Components are a set of standards currently being produced by Google engineers as a W3C specification that allow for the creation of reusable widgets or components in web documents and web applications. The intention behind them is to bring component-based software engineering to the World Wide Web. The components model allows for encapsulation and interoperability of individual HTML elements. Support for Web Components is present in Chrome and Opera and is in Firefox (with a manual configuration change). Microsoft's Internet Explorer has not implemented any Web Components specifications yet. Web Components consist of 4 main elements: Custom Elements, Shadow DOM, HTML Imports and HTML Templates.