Using Userform code in a Workbook
 

I have written a timer sub routine in a Userform.
1. How do I utilise this in a workbook?
2. When I run the code in the VBA I cannot input data into cells in th
worksheet. Is it possible to be able to do this

--
Jake
-----------------------------------------------------------------------
Jake8's Profile: http://www.excelforum.com/member.php...nfo&userid=422
View this thread: http://www.excelforum.com/showthread.php?threadid=32049

Using Userform code in a Workbook
 

Jake,

1) You can show the form with code like

UserForm1.Show vbModeless

2) See above.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jake8" wrote in message
...

I have written a timer sub routine in a Userform.
1. How do I utilise this in a workbook?
2. When I run the code in the VBA I cannot input data into
cells in the
worksheet. Is it possible to be able to do this.


--
Jake8
------------------------------------------------------------------------
Jake8's Profile:
http://www.excelforum.com/member.php...fo&userid=4226
View this thread:
http://www.excelforum.com/showthread...hreadid=320493

Using Userform code in a Workbook
 

Thanks.

The Userform code brings up a form with a textbox (displaying a timer
and a button (to stop the timer). Unfortunately I cannot enter any dat
while the timer is running and the user can close the form whereas
need the timer to stay on the worksheet. Can you help.. Thanks i
advance

--
Jake
-----------------------------------------------------------------------
Jake8's Profile: http://www.excelforum.com/member.php...nfo&userid=422
View this thread: http://www.excelforum.com/showthread.php?threadid=32049