Formatting an Inputbox variable

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 :p

Excel VBA question moved to Office Development.

Welcome to the forums!

You can't use formatted input with an InputBox, but you could make your own control/form that traps input to conform to your specs.

ooooooooooooooooooooooooooooh
bummer lol

thanks for the help! :D

Is there anyway to change the font style/size on the Inputbox default message?...not the user input but the message itself.


Gracias :D

It's possible, but it's complicated.

It would be easier to create your own form to act as an inputbox instead.

Sweeet. Thanks man!