dear Excel Experts,
I have a userform which retrieves the data from the excel database
in the REV textbox user can change it
and then changed data are uploaded into the same excel database again.
Second code:
I would like to validate the data entry format, so users can enter only commas as decimal separator only, only as %, so 0,75% (not 0.75% and not 0.75)
I also want to avoid empty text box or if it's empty it should be changed to 0 with the second code.
How can I limit / validate the textbox entry?
Should I validate every single textbox? how should I do it?
Thank you in advance for your kind advice
E.
I have a userform which retrieves the data from the excel database
Code:
UF_Contracting.REV = Format(Sheets("A").Range("Data_Start").Offset(TargetRaw, 64).Value, "Percent")in the REV textbox user can change it
and then changed data are uploaded into the same excel database again.
Second code:
Code:
Sheets("A").Range("Data_Start").Offset(TargetRaw, 64).Value = Replace(UF_Contracting.REV, "%", "") / 100I would like to validate the data entry format, so users can enter only commas as decimal separator only, only as %, so 0,75% (not 0.75% and not 0.75)
I also want to avoid empty text box or if it's empty it should be changed to 0 with the second code.
How can I limit / validate the textbox entry?
Should I validate every single textbox? how should I do it?
Thank you in advance for your kind advice
E.
