Hmmmm.
Thank you,
But I actually don't understand what it is you want to do with this code or where to place it.
Codes I have in Textbox1
Sub TextBox1_Change.
Line 1 - What I write in Textbox1 will be written in Cell A2.
Line 2 - Will change the comma I type as the decimal separator to a dot, to be able to calculate the amount in Cell A4.
If I don't change the decimal comma separator to a dot, it won't calculate the amount in Cell A4.
Sub TextBox1_Exit.
This is REM.
But I can instead put the Line 2 code from above here, to change the comma I type to a dot, when I Exit TextBox1.
And then I want to show the 1000 separator in TextBox1 too on Exit, if it is possible, without destroying the amount calculation in A4.
The Open Button on Sheets("Ark1") which will open the Userform1.
Sub CommandButton1_Click
This open Userform1
If there is a value in Cells A1 or A2 or both, I want too show the value in TextBox1 and TextBox2, when opening the Userform.
With the 1000 separator and the decimal separator.
But without it destroy the calculation in Cell A4.
And I want it to show two digit in the decimal cifre if I type a zero(0) as the last digit and not only one digit.
Not xx.5 - But xx.50
The codes I REM is just codes I tried, but they didn't worked for me.
Note:
When you load the userform and show the value from the cells A1 and A2 in the Textboxes, it will probably have an influence on the calculation in Cell A4.
This because you will load the value from the Cells in the TextBox_Change, which again will change the value in the cells.
I really can't figure all this out.
And I want to make simple codes too, because I will have a lot of Textboxes in each Userform.
I'm trying to make a Userform with 4 Textboxes for each date in a months, calling it "Master".
And then to Export and save it, too Import it again and rename it as each month in a year.
Then I can reuse the Userform, only change a few things in each Userform codes after renaming it to a new month.
I have each month on a new Tab in Excel - Jan - Feb - Mar - Apr - and so on.
If it's possible for you, you can try to make the codes for me.
And then upload the Workbook with your codes, for me to see how you did it.
Bookmarks