is there a command

Application.Run macro1 ,"yes"

"yes" is the answer to the inputbox question

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" <(E-Mail Removed)> wrote in message
news:5a2901c48172$ba859cf0$(E-Mail Removed)...
> is there a command
>
> Application.Run macro1 ,"yes"
>
> "yes" is the answer to the inputbox question

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" <(E-Mail Removed)>
wrote in message
>news:5a2901c48172$ba859cf0$(E-Mail Removed)...
>> is there a command
>>
>> Application.Run macro1 ,"yes"
>>
>> "yes" is the answer to the inputbox question
>
>
>.
>

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

--
Regards,
Tom Ogilvy

<(E-Mail Removed)> wrote in message
news:5f7a01c48176$7c4de420$(E-Mail Removed)...
> 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" <(E-Mail Removed)>
> wrote in message
> >news:5a2901c48172$ba859cf0$(E-Mail Removed)...
> >> is there a command
> >>
> >> Application.Run macro1 ,"yes"
> >>
> >> "yes" is the answer to the inputbox question
> >
> >
> >.
> >