Hello folks! It's been a few years since I've written VB codes.

I'm using VBA for Excel and was wondering if there is a way to limit the user's entry in the Inputbox function.....in such a way like the old VB mask box.


for instance...

variable = Inputbox ("whatever")

...but when the Inputbox window pops up....I only want them to enter a value in Scientific Notation. I don't want them entering a string or any regular number.

Instead of having them enter a value then checking for it....is there a way to only allow them to enter that type of format?


I hope I'm making some sense.....maybe I need more sleep