inputbox Auto response

[Joe]

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

 

[Dick Kusleika]

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"

 

[Tom Ogilvy]

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.

 

[Joe]

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




.