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