Using Userform code in a Workbook

[Jake8]

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

 

[Chip Pearson]

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]

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