Where a Macro is called

Montez659

Well-known Member
Joined
May 4, 2005
Messages
918
I know the info that I am about to give may be vague, but there is such an overload of stuff I don't even know where to begin. So please ask questions and if I can answer them I will.

I copied a Form that we have in an existing db and pasted it within the same db. I have changed the record source to a new table. However, one thing is eluding me. There is a search box that obviously calls a macro called "Search." I copied this macro and renamed to Search2. For the life of me, I cannot find what to change within the form to make sure that Search2 is called instead of Search.

I have checked all properties of "searchBox" and there is no event trigger (unless it is somewhere that I can't see it). I have looked at the code and there is no After Update or On Enter code entered, yet when I type in something to be searched and press enter, it triggers something because I get an error message telling me that something didn't work and it references "Search" instead of "Search2" like I would like it to.

Where else can I look to find where "Search" would be called and change it? Like I said, I know that this is vague and I am not sure what extra info that you would need, but if it is within my power than I will answer it. Thanks in advance!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Figures...I found it. It was a separate control called searchGo.

I appreciate all of the brain waves that produced this fine result. From this moment forward I resolve to post all of my questions immediately instead of searching for hours because I know in the end that as soon as I post it, I will find the answer.
 
Upvote 0

Forum statistics

Threads
1,224,618
Messages
6,179,917
Members
452,949
Latest member
beartooth91

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top