Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Multipage forms

How can I update one page on a multipage form after some information is
entered on another? eg Information is entered on Page 3 and transferred to a
worksheet The information displayed on page 4 now needs to be updated from
what was loaded when the form initialized.

Many Thanks in advance
--
AJM1949
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 772
Default Multipage forms

Not sure that i totally understand what you need, but check out the multipage
change event, if you put something there then it will run your code when you
change sheets such as updating page 4 when you switch from page 3. If this is
not what you mean please provide a little more info on what you are trying to
update and when.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"AJM1949" wrote:

How can I update one page on a multipage form after some information is
entered on another? eg Information is entered on Page 3 and transferred to a
worksheet The information displayed on page 4 now needs to be updated from
what was loaded when the form initialized.

Many Thanks in advance
--
AJM1949

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Multipage forms

Thanks John

That did the trick.
--
AJM1949


"John Bundy" wrote:

Not sure that i totally understand what you need, but check out the multipage
change event, if you put something there then it will run your code when you
change sheets such as updating page 4 when you switch from page 3. If this is
not what you mean please provide a little more info on what you are trying to
update and when.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"AJM1949" wrote:

How can I update one page on a multipage form after some information is
entered on another? eg Information is entered on Page 3 and transferred to a
worksheet The information displayed on page 4 now needs to be updated from
what was loaded when the form initialized.

Many Thanks in advance
--
AJM1949

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
User Forms Multipage Background/Foreground Colors Bryan44 Excel Programming 3 October 26th 06 03:32 AM
Multipage forms imported in XP DKS Excel Programming 12 September 22nd 06 11:58 PM
Excel forms - authorise / deny forms Ian Manning Excel Programming 1 May 8th 06 05:03 PM
Calling Forms from Forms - Exit problems Stuart[_5_] Excel Programming 3 May 25th 04 06:50 AM
Multipage control on Excel VBA forms James Garner Excel Programming 2 December 4th 03 06:37 AM


All times are GMT +1. The time now is 06:04 PM.

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"