clarification
 

is there a command

Application.Run macro1 ,"yes"

"yes" is the answer to the inputbox question

clarification
 

if

Sub Macro1(sStr as String)
ans = InputBox(Default:=sStr)
End Sub

then yes.

If the inputbox is put up by an addin or something besides your code then
probably not.

--
Regards,
Tom Ogilvy


"Michael Joe" wrote in message
...
is there a command

Application.Run macro1 ,"yes"

"yes" is the answer to the inputbox question

clarification
 

value=(application.run macro1,yes)
what does this do then


-----Original Message-----
if

Sub Macro1(sStr as String)
ans = InputBox(Default:=sStr)
End Sub

then yes.

If the inputbox is put up by an addin or something
besides your code then
probably not.

--
Regards,
Tom Ogilvy


"Michael Joe"
wrote in message
...
is there a command

Application.Run macro1 ,"yes"

"yes" is the answer to the inputbox question


.

clarification
 

As written I doubt it would do anything except, perhaps raise an error.

--
Regards,
Tom Ogilvy

wrote in message
...
value=(application.run macro1,yes)
what does this do then


-----Original Message-----
if

Sub Macro1(sStr as String)
ans = InputBox(Default:=sStr)
End Sub

then yes.

If the inputbox is put up by an addin or something
besides your code then
probably not.

--
Regards,
Tom Ogilvy


"Michael Joe"
wrote in message
...
is there a command

Application.Run macro1 ,"yes"

"yes" is the answer to the inputbox question


.