spin button increase by decimal

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I have a spin button to use for increase a value in text box by decimal.

The minimum increase is one.
I need synchronize the value user enter.
I have

Screen.ActiveControl.Value = Screen.ActiveControl.Value / 10

on text box exit.

The problem is when user go back in text box will divide one more time.

Are there any workaround for this issue?

Your help is great appreciated,
 
Move the code to the After Update event.
The Exit event fires when you leave the control whether a change has been
made or not.
The After Update event fires only when a change has been made to the value
of the control.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Forms Spin Button - Return to 1 after max value 0
Windows 10 How to improve network speed in Windows 10 by increasing IRPStackSize 5
Excel Excel 2007 won't stop rounding down my formula results! 5
Decimal number with ListCount in the expression 4
Excel Stop Excel from displaying rounded values 4
Option for Two Decimal 4
Access stripping decimal places in query 1
Increment buttons 4

Back
Top