Currency symbol always in box

Hi

I'm fairly new to vba and I'm currently creating a user form. Is it possible to have the currency symbol permantly in the text box? So far I have it so when the user opens to input it reads "£0.00" but when the user clicks on the box to add information I want the 0.00 part to disappear leaving the £ sign only, and also so the £ cannot be removed.... Is this possible?

You can easily set the box to have a value of "£" when the userform is initialized. making it so the £ is tricky. Why not just have 2 boxes, 1 with the £ and the other for data entry?

Hi

Thanks for your reply, I managed to do it eventually but rather than having a £ sign there all the time I used the if function on the after update and enter cosings so on the after update it shows "enter value here" and on the enter it shows "£", but it still is not there permantly, the £ can be deleted out.

1 step at the time I suppose, I'm picking it up slowly haha

Hi

In that scenario I use a label to hold the Currency symbol. It makes all the coding a lot simpler.

Formated to match your textbox, it looks like part of the box but cannot be deleted.

Ah, yes i see what you mean, as long as the cell this information is going into is formatted to "currency" then it doesnt matter if the "£" is in the text box at all

Thank you

Hi

In that scenario I use a label to hold the Currency symbol. It makes all the coding a lot simpler.

Formated to match your textbox, it looks like part of the box but cannot be deleted.