Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEED A MACRO CODE TO USE IN A USERFORM | Excel Discussion (Misc queries) | |||
UserForm code help needed. | Excel Programming | |||
UserForm code help needed. | Excel Programming | |||
UserForm code help needed. | Excel Programming | |||
VBA code for Userform | Excel Programming |