• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

Percentage calc on userform

Hello Experts,

The Percentage calc on the Index field returns ie: 6500% when entering "6.5" with the userform keypad, it should return 6.5%. The percentage calc functions correctly when using a hardware keyboard. Can the code be modified to return the correct value?
Thanks,

biker9
0
biker9
Asked:
biker9
1 Solution
 
Elton PascuaCommented:
Probably when entering using the keyboard, % is being attached to the number? Either you add % on the userform keypad or configure the field that when no % is found on the entry, divide it by 100.
0
 
biker9Author Commented:
Thanks for the help, this helped towards the solution.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now