Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

**david gonzalez** · 10-01-2014, 09:28 AM

Good Morning all !!!!!!!!

I'm successfully using a code to Search and Highlight string Formats in a single Cell,
but i would-like to change or accept an additional formats,

For example :

Right now it work perfect searching and highlightig this format :
01-02-03-04-05
03-09-15-25-35
10-15-25-35-36

and i would like to change or accept an additional format like this :
1,2,3,4,5
3,9,15,25,35
10,15,25,35,36

Please Login or Register  to view this content.

Thank you,

Best Regards

David

**Leith Ross** · 10-01-2014, 04:25 PM

Hello David,

You can use this pattern...

Please Login or Register  to view this content.

However, this will not match a number unless it is followed by a comma.

Any number not followed by a space or at the end of the string will be ignored. For example 1,2,4b. the 4b will not be included in the match

**david gonzalez** · 10-01-2014, 04:56 PM

Hi Mr Leith Ross;
I might doing something wrong,
The pattern was added, and Let say in F1 i Input 1,3,15,25,36, then everything change to Red

1,2,3,4,5
3,9,15,25,35
10,15,25,35,36

Please Login or Register  to view this content.

Thank you,

Best Regards

David

**Leith Ross** · 10-01-2014, 05:01 PM

Hello David,

I am not sure I understand the problem. Any matching patterns in the cell are to be colored red. Your example indicates that.

Are you saying ALL characters in the cell are red ?

**david gonzalez** · 10-01-2014, 05:17 PM

Hi Mr Leith rosss,

with Actual Format this code search and highlight the numbers that match from Cell F1 vs Column range V5 down,
Let say i Input in F1 : 01,03,15,25,36, Then matched numbers in Col V5 down got highlighted
as :

01,02,03,04,05
03,09,15,25,35
10,15,25,35,36

Desired code, i need to work with format 1,2,3,4,5 (not with 01,02,03,04,05)
so necessary new output can be as :
1,2,3,4,5
3,9,15,25,35
10,15,25,35,36

Thank you so much and i'm sorry for the lacks of explanation..

Best Regards

David

**david gonzalez** · 10-01-2014, 05:48 PM

Hi Leith Ross,

yes sir, All the character in the cell are red.
what i need is to color in red the matched numbers.

Thank you,

Best Regards

David

**Leith Ross** · 10-01-2014, 06:34 PM

Hello Daid,

Try this macro.

Please Login or Register  to view this content.

**Leith Ross** · 10-01-2014, 06:35 PM

Hello Daid,

Try this macro.

Please Login or Register  to view this content.

**david gonzalez** · 10-01-2014, 06:46 PM

Hi mr Leith Ross,

(I think the code is posted twice)

It does't work, it highlight some matched numbers but also highlight some others numbers that don't match.

Best Regards

David

**Leith Ross** · 10-01-2014, 07:02 PM

Hello David,

Since I am not really understanding what you want to do, you should post a workbook.

Include a before and after example of the data. This should match your actual data.

Include any notes, comments, or explanations you feel will help in explaining the end result.

How To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.

**david gonzalez** · 10-01-2014, 08:33 PM

Hi mr Leith Ross,

I'm sorry it took me so long, file was too big and i had to shrink it.

Here the file,and on same sheet already have the 2 codes and search boxes with small numbers list with both Format

Thank you !!

Best Regards

David

**Leith Ross** · 10-02-2014, 03:57 PM

Hello David,

Here is the macro. It has been added to and tested on the attached workbook.

Please Login or Register  to view this content.

**david gonzalez** · 10-02-2014, 04:05 PM

Hi Mr Leith,

Yes Sir, it worked !!!!!!!!!!!!
I been reading about about VBA expression operator and is not easy..

Thank you so much !!!!!!!!!!!!!

Best Regards

David

**Leith Ross** · 10-02-2014, 04:26 PM

Hello David,

De nada. Próxima vez usted puede escribir sus preguntas en español.

Thanks for marking your solved.

**david gonzalez** · 10-02-2014, 05:02 PM

Hola Mr Ross,

esta bien voy a tratar, para mi es un poco dificil la traduccion al español de la terminologias o nombres de formulas de excel.

Muchas Gracias

Saludes

David.

**Leith Ross** · 10-02-2014, 05:13 PM

Hello David,

Entendido. Puede escribir la fórmula nombres y terminología en inglés. Sí?

**david gonzalez** · 10-02-2014, 05:22 PM

Hi Mr Ross,

Claro que si..., Imaginese describiendo en español "COUNTIF" (CONTARSI) o "SUMPRODUCT" (SUMARPRODUCTO)

Sound weird,

verdad? lol..

Saludes

David

**Leith Ross** · 10-02-2014, 06:00 PM

Hello David,

I am used to hearing Spanish and English words used together. In California it is very common. We call it Spanglish.

**david gonzalez** · 10-02-2014, 08:54 PM

Hi Mr Leith,

En miami tambien se le dice Spanglish, antes era bien popular sobre todo en la comunidad cubano americana, pero ha ido desapareciendo, Hoy dia se ha vuelto bastante popular en los jovenes..
Nosotros los viejos usamos el Spanglish cuando hablando Ingles no samos la traduccion correcta de una palabra de ingles a español, Entonces en medio de la conversacion we mix la palabra, Y el Interlocutor o sea la otra persona con la que conversamos contesta : "Ehhh ????" lol...

Saludes

David

Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

LinkBack

Thread Tools

Rate This Thread

Display

Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Re: Modify VBA Code to Acept search & highlight Other string Format e.i 01-02,03 to 1,2,3

Thread Information

Users Browsing this Thread

Similar Threads

Modify connection string - VBA Code

[SOLVED] VBA Search for string, modify and re-enter

[SOLVED] Modify code to search first matching string from right to left.

Modify Search code to look for specified text

modify code for search button

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions