Near-Exponential VBA Conversion

The macro in this tutorial creates a near exponential variable conversion to be used for very large dynamic range input data entry . If for instance, we have to adjust a parameter from 1 to 1 million we can either make a spin button which can go from 1 to 1 million in unity steps (which would take for ever), or implement an exponential scheme. We would like an exponential series of powers of 2 but numbers of 128, 256 or 512 are not appealing. Instead we could use a compromise electrical engineers have discovered long ago, a series such as: 100, 200, 500, 1000, 2000… etc. The last group of numbers are close enough to powers of two, have just the first digit non-zero and the rest of digits zeros. People like that. This tutorial will explain few options of creating those series using extremely simple VBA code.


Leave a Reply

Your email address will not be published. Required fields are marked *