Add msg Box to input variable value

[Gene Augustin]

I have a macro that I want to be able to input a value for a variable. The
variable is an integer, ItemNo

I want to be able to enter a number, say 5000, in the field of the box and
have that value set in the macro and the box go away.

 

[Laroche J]

Gene Augustin wrote on 2009-04-05 13:12:

I have a macro that I want to be able to input a value for a variable. The
variable is an integer, ItemNo

I want to be able to enter a number, say 5000, in the field of the box and
have that value set in the macro and the box go away.

What you need is not MsgBox (a window that only displays a message), but
InputBox (a window that allows user input). Look in help for details.

Syntax
expression.InputBox(Prompt, Title, Default, Left, Top, HelpFile,
HelpContextId, Type)


JL
Mac OS X 10.4.11, Office v.X 10.1.9