I'm sorry if this problem is not very clear, or if it has a very simple solution that I am too simple to see.
I'm new to vba, and I have butchered a couple of blocks of code from some very kind people in order to make a userform. 4 of the text boxes on the form are for users to input percentages, which are then used in a calculation on the spreadsheet, the spreadsheet then adds some info to the userform, which the user then clicks a button to submit all the data back to the 'database' on the spreadsheet.
I have got it to work ok, so that there are spin buttons linked to the text boxes, and it won't let you add the results if it's not a number between 0-100 entered in the text box. The problem is that when it lands on the worksheet, if the user has inputted '1', it goes to the worksheet as '100%' rather than '1%' (I guess because excel treats percentages as fractions). I really don't want the user to have to input '0.10' for 10% etc. I have tried to change the cell on the worksheet to 'percentage', but the userform seems to overwrite the formatting. I have the same problem with a currency amount actually, it seems to work okay, except excel tells me it is a number stored as text.
Is there a way to format the numbers/text boxes so that inputting '1' in the text box really does mean '1%'?
Any help greatly appreciated.
Bookmarks