MsgBox enter value the use it

[mcdhappy80]

What button argument I need to provide, for MsgBox function, in order to create a message box that will allow me to enter the number value and the use that value?

Thank You

 

[Banana]

Well, it's not MsgBox you want, but rather InputBox, which works okay for a simple input. Look in VBA Editor's helpfile for InputBox function.