Hi, I`ve been working on a userform for a few days now and it is almost finished.
However the finishing touch always takes 50% of the time.....
Now I can`t post the whole file here but perhaps someone will spare me some time and is kind enough to take a look at it?
There are 2 problems with the userform:
1: I want to date to fill to 0000 so 23 becomes 0023 automatically. (I uses all types of functions: Right$("000"& etc) formatting the cell with custom format 0000. Nothing seems to work.
2: If data entered in one of the textboxen is notnumeric an msg appears. Thsi work fine but if you backspace in a textbox to delete any alphanumeric characters you also get the message. I cannot seem to avoid this.
So, I am aware that this will be a major thing to ask from someone but I would be so glad if someone tried to help me out.
If someone is interested, I`ll send you the file.
thnks!
Dinictus.
However the finishing touch always takes 50% of the time.....
Now I can`t post the whole file here but perhaps someone will spare me some time and is kind enough to take a look at it?
There are 2 problems with the userform:
1: I want to date to fill to 0000 so 23 becomes 0023 automatically. (I uses all types of functions: Right$("000"& etc) formatting the cell with custom format 0000. Nothing seems to work.
2: If data entered in one of the textboxen is notnumeric an msg appears. Thsi work fine but if you backspace in a textbox to delete any alphanumeric characters you also get the message. I cannot seem to avoid this.
So, I am aware that this will be a major thing to ask from someone but I would be so glad if someone tried to help me out.
If someone is interested, I`ll send you the file.
thnks!
Dinictus.