#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default userform

Hi, if I create a userform with 4 textboxes and run the form. Is it
possible to add data to the textboxes. I have live data streeming into
excel, which updates ok when the form is running. When certain
conditions are met Id like to update the userform text boxes. Is this
possible without putting a command button on the form.
Regards Robert

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default userform

If the userform is shown as modeless, then worksheet events should be able to
fire and update its values.

--
Regards,
Tom Ogilvy


"RobcPettit" wrote:

Hi, if I create a userform with 4 textboxes and run the form. Is it
possible to add data to the textboxes. I have live data streeming into
excel, which updates ok when the form is running. When certain
conditions are met Id like to update the userform text boxes. Is this
possible without putting a command button on the form.
Regards Robert


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default userform

Thanks for your reply Tom, Ive made the form modeless and it updates
fine.
Regards Robert
Tom Ogilvy wrote:
If the userform is shown as modeless, then worksheet events should be able to
fire and update its values.

--
Regards,
Tom Ogilvy


"RobcPettit" wrote:

Hi, if I create a userform with 4 textboxes and run the form. Is it
possible to add data to the textboxes. I have live data streeming into
excel, which updates ok when the form is running. When certain
conditions are met Id like to update the userform text boxes. Is this
possible without putting a command button on the form.
Regards Robert



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform to enter values and shown in same userform in list helmekki[_104_] Excel Programming 0 November 19th 05 03:23 PM
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Activating userform and filling it with data form row where userform is activate Marthijn Beusekom via OfficeKB.com[_2_] Excel Programming 3 May 6th 05 05:44 PM
Access from add_in userform to main template userform.... Ajit Excel Programming 1 November 18th 04 05:15 PM
Linking userform to userform in Excel 2003 missmelis01 Excel Programming 2 August 27th 04 08:07 PM


All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"