Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 112
Default Running form procedures from sheets

Hello,
I have a procedure in a worksheet copying information to another sheet then
it returns to the form. Before/When the form comes into focus again I'd like
the form updated so the new information from the underlying sheet is
displayed.
I have a procedure for that, in the form, normally used for updating the
form when
enetering information in it! Now I'd like the procedure in the sheet to run
the procedure in the form but Run("Calculation!SumUpdate") doesn't work. It
says the macro can't be found even though the form has come into focus again.
How to do this?
Best regards
Mats
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
Running total on form WCDoan Excel Discussion (Misc queries) 2 October 5th 07 09:11 PM
Running sql stored procedures from Excel in-over-his-head-bill Excel Discussion (Misc queries) 0 July 5th 06 06:30 PM
making a sum of a eq. with a var running form 0-infinity. silverspace Excel Discussion (Misc queries) 1 May 18th 06 10:21 AM
Closing form turns off commandbar control procedures?? Caro-Kann Defence Excel Programming 0 January 28th 05 09:35 PM
Help with automatically running procedures when an Excel file is accessed via web stigma32 Excel Programming 0 July 21st 04 10:34 PM


All times are GMT +1. The time now is 08:27 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"