Searching a text box for characters and replace.

**sungen99** · 06-08-2015, 09:19 AM

I would like to search “textbox42” for “—“ (two dashes) and replace it with a Wingdings “w”. i am trying to create the little triangle.

**bob33** · 06-08-2015, 09:26 AM

Have you tried this for insight:
https://support.office.com/en-us/art...2-333dead6ae33

**sungen99** · 06-08-2015, 09:39 AM

Yes I have and when targeting a text box the find replace option is grayed out. I always try to use the record macro option before asking the Forum for help.

**6StringJazzer** · 06-08-2015, 09:42 AM

To answer your question:

Private Sub TextBox42_Change()
   TextBox42 = Replace(TextBox42, "--", "w")
End Sub

But you cannot mix fonts in a textbox. It all has to be the same font. So you cannot insert a Wingdings triangle in the middle of Arial text, for example. (You can do that in a cell, but not a textbox.)

Edit: I assume you are talking about a textbox control, not a textbox shape.

**6StringJazzer** · 06-08-2015, 09:43 AM

bob33, "Find or replace text and numbers on a worksheet" applies only to worksheet cells and not textboxes.

**sungen99** · 06-08-2015, 02:14 PM

Thank you all for the help. Looks like I need to do this manually then.

**6StringJazzer** · 06-08-2015, 02:29 PM

Here's an example using characters available in the Arial character set. You just have to pick a font that is available, and then pick one of the first 255 characters.