Is there a way to remove certain characters from a userform textbox, i.e. like the find and replace on a worksheet.
I don't want to copy the data to a cell on a sheet first as I have a selection change event which interferes with things, I would prefer to be able to do the changes within the userform itself.
I want to replace/ remove characters such as fullstop(.) and plus (+).
So text in textbox might be 9.15+34 so I want it yo end up as 91534 or it might be A35+Kl1.C3 which would end up as A35Kl1C3.
Thanks
I don't want to copy the data to a cell on a sheet first as I have a selection change event which interferes with things, I would prefer to be able to do the changes within the userform itself.
I want to replace/ remove characters such as fullstop(.) and plus (+).
So text in textbox might be 9.15+34 so I want it yo end up as 91534 or it might be A35+Kl1.C3 which would end up as A35Kl1C3.
Thanks