inputbox Auto response
 

message2
the input box comes up. i want to in vb code (outside
excel) run the macro and say yes to the input box ?
so no pop ups


message1
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox type
of
thing with excel.Application.DisplayAlerts = False but
for a inputboxs.

Mike

inputbox Auto response
 

Joe

You can use Application.SendKeys to do that, but you shouldn't. If you
don't want a popup, don't use the InputBox function. Instead of

x = InputBox(...)

use

x = "MyValue"

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Joe" wrote in message
...
message2
the input box comes up. i want to in vb code (outside
excel) run the macro and say yes to the input box ?
so no pop ups


message1
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox type
of
thing with excel.Application.DisplayAlerts = False but
for a inputboxs.

Mike

inputbox Auto response
 

Note - your inability to accurately ask your question and completely
describe your situation is just resulting in other people wasting their time
telling you the same information over and over.

Rather than continuing to spam the newsgroup with an inept repetitive
question, why not compose a complete picture of what your situation is and
post that. Using inputbox is probably not the correct term to use in your
question. Just a guess of course.
--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
message2
the input box comes up. i want to in vb code (outside
excel) run the macro and say yes to the input box ?
so no pop ups


message1
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox type
of
thing with excel.Application.DisplayAlerts = False but
for a inputboxs.

Mike

inputbox Auto response
 

Thanks
-----Original Message-----
Joe

You can use Application.SendKeys to do that, but you
shouldn't. If you
don't want a popup, don't use the InputBox function.
Instead of

x = InputBox(...)

use

x = "MyValue"

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Joe" wrote in
message
...
message2
the input box comes up. i want to in vb code (outside
excel) run the macro and say yes to the input box ?
so no pop ups


message1
I have basic code running a macro in a excel sheet.
i want to set the input box automatically to yes.
Then finish running the macro...

Other idea is to:
there is a default of yes so I could do a msgbox
type
of
thing with excel.Application.DisplayAlerts = False
but
for a inputboxs.

Mike



.