Is there some line I can include in a form that does the 'click' o
click OK for me. I have a form that processes some data, and since
know the data well, I just want the forms to be processed (about 500 o
them) on a batch mode. The way it is set up now, I have to click ok (o
enter from keyboard), each time.

When the form is called the tab focus and tab index are set to the O
command button. I need some line to say that it is clicked.

More on why I need this, this way....

I am tweaking a form created by someone before me to input certai
range of data. The form has a bunch of code that check for types o
data and prompts for user to select the range. Upon selecting the rang
and click 'OK', it formats the data, and sends some key information t
the calling sub. All this happens within the user form. I don't inten
to change the form, but I'm having the task to redo some work (abou
500 inputs). So if I can set my machine to do this on a batch mode
will save me some time.

Thanks
D

--
reachthepalac
-----------------------------------------------------------------------
reachthepalace's Profile: http://www.excelforum.com/member.php...fo&userid=3172
View this thread: http://www.excelforum.com/showthread.php?threadid=53323