Transform into ActiveX Control

Good day everyone...

I have file already working but i need some revision and additional too...
Search box is from cell B2 (working)
I want to transform it into ActiveX control (text box)
and additional option button (activeX) with vbacode to search batch code number...

Thank you in advance...

Hi !

My 2 cents ppv : if you are not on your own with your workbook so if you share it on another computers with different Excel versions
so avoid any ActiveX control …

for one computer only but with other users just in case im not available...
and some users are not aware if they mess up that's why im thinking about textbox
instead of searchbox in cell...

I need some help for adjustment on searchbox(activeX control).
1. I've got an error when i enter empty (Run-time error: 13 (Type mismatch)
2. when (no data enter) or (no matched data) should be return to searchbox after the message box.
3. additional vba code for option button (Batch Code No.)

1) Add CommandButton (CommandButton1), then add code

Please Login or Register  to view this content.

2) Replace "SearchSerial" with code below.

Please Login or Register  to view this content.

Thank you once again Mr. Jindon...
But i manage to put SearchBox_KeyUp (Enter key) and end up on looping message box when no data enter or no matched data unless i press escape key or by mouse button to return to Searchbox.
Is there any way to stop looping when i press OK button with [enter] key and promptly return to searchbox?

Then use KeyDown, instead of KeyUp.

It works... Thank you very much Mr. Jindon...
by the way can i use * or ? to search before or after batch code#?

It depends on how you want it.

I you want any part a(i, 6) Like "*" & myNum & "*", my code should match only exact match within a string.

i got an error after changing the pattern

Run-time error '5018':
Application-defined or object-defined error
on

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Working awesome...
Thank you so much for your support Mr. Jindon...

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.