Find replace within a textbox.

[sungen99]

I want to search / replace within textBox42 for "--" and replace it with Wingdings font "s".

Could someone help me with this please as the record option does not yield the correct results.

Thanks very much.

[ericbartha]

I do not know what the official answer is, but you could set the data within the textbox to a string, then either search that string, or paste it into a cell tempararily, then find and replace on the cell. Move cell back to textbox

Something like this: ??

Please Login or Register  to view this content.

[ericbartha]

Okay, after a quick google, I would set sTemp = textbox 41 then replace function on sTemp, setting it to sTemp2, then set textbox42 = sTemp2.

https://msdn.microsoft.com/en-us/lib...(v=vs.90).aspx

Hope this helps!