Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data bound VBA forms
I have a VBA form with a MulitPage control that reads
from/Submits to an excel sheet. Each control on the form calls a submit procedure that loads the data into correct place in the database (using a the cells property). This procdeure is called from the After_Update event of the control My only problem is that if you enter data in the control and change pages on the multipage without tabbing, After_Update doesn't fire and the data doesn't get submitted. Anyone know how to force the After_Update when selecting a new page on the multipage? This is driving me (and my users) nuts!! Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data bound VBA forms
The change event of the multipage fires when pages are changed. You can use
this event to ensure the data is updated. -- Regards, Tom Ogilvy "Andy" wrote in message ... I have a VBA form with a MulitPage control that reads from/Submits to an excel sheet. Each control on the form calls a submit procedure that loads the data into correct place in the database (using a the cells property). This procdeure is called from the After_Update event of the control My only problem is that if you enter data in the control and change pages on the multipage without tabbing, After_Update doesn't fire and the data doesn't get submitted. Anyone know how to force the After_Update when selecting a new page on the multipage? This is driving me (and my users) nuts!! Andy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data bound VBA forms
Thanks Tom,
Andy -----Original Message----- The change event of the multipage fires when pages are changed. You can use this event to ensure the data is updated. -- Regards, Tom Ogilvy "Andy" wrote in message ... I have a VBA form with a MulitPage control that reads from/Submits to an excel sheet. Each control on the form calls a submit procedure that loads the data into correct place in the database (using a the cells property). This procdeure is called from the After_Update event of the control My only problem is that if you enter data in the control and change pages on the multipage without tabbing, After_Update doesn't fire and the data doesn't get submitted. Anyone know how to force the After_Update when selecting a new page on the multipage? This is driving me (and my users) nuts!! Andy . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using formula result for data series bound | Excel Discussion (Misc queries) | |||
What does "Workbook has no bound sheets" mean? | Excel Discussion (Misc queries) | |||
What does "Workbook has no bound sheets" mean? | Excel Discussion (Misc queries) | |||
Cell Bound Combo Box | Excel Programming | |||
Listbox with Bound Columns | Excel Programming |