I need to know how to create a pause in a macro that will allow me t
enter a varaible in a cell and then move to another cell after it i
entered, enter a another variable and so on. The variable entered wil
be a number that will be different almost every time it is entered an
ultimatley in the end be used in a calculation.


Thanks
Keit

--
kabu
-----------------------------------------------------------------------
kabur's Profile: http://www.excelforum.com/member.php...fo&userid=1609
View this thread: http://www.excelforum.com/showthread.php?threadid=27542

Keith,

If you have Excel 2000 or later, set the form's ShowModal property to False,
this will allow you to switch between form and worksheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kabur" wrote in message
...

I need to know how to create a pause in a macro that will allow me to
enter a varaible in a cell and then move to another cell after it is
entered, enter a another variable and so on. The variable entered will
be a number that will be different almost every time it is entered and
ultimatley in the end be used in a calculation.


Thanks
Keith


--
kabur
------------------------------------------------------------------------
kabur's Profile:
http://www.excelforum.com/member.php...o&userid=16091
View this thread: http://www.excelforum.com/showthread...hreadid=275421