Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I blanket update all controls inside a frame?
I have several controls (i.e. textbox, combobox and checkbox) inside a frame
in a form and need ALL their values to update to their corresponding cells in a worksheet when click a command button. Is there a quicker way to do so rather than writing a line for each control to force the blanket update? Thanks in advance :-) Sam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I blanket update all controls inside a frame?
hi, Sam !
I have several controls (i.e. textbox, combobox and checkbox) inside a frame in a form and need ALL their values to update to their corresponding cells in a worksheet when click a command button. Is there a quicker way to do so rather than writing a line for each control to force the blanket update? ... (assuming every control is "linked" to each cell)... try "blanking" (in one step) "their corresponding cells" -?- if any doubts (or further information)... would you please comment ? regards, hector. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I blanket update all controls inside a frame?
Hi Hector,
The controls are linked to cells (with their ControlSource set to the cells). The problem I had was that when the worksheet updates, not all these controls update to reflect the changed value. So what I do now is to code each control's value to its corresponding cell in the subroutine CommandButton_Click(). This ensures all controls always show their linked cells value in real time when click the button, and it's working fine. I just wonder if there's an easier way to refresh multiple form controls without referring to the worksheet in the code like I did (as the form controls already have their ControlSource specified in property)? Sam "Héctor Miguel" wrote: hi, Sam ! I have several controls (i.e. textbox, combobox and checkbox) inside a frame in a form and need ALL their values to update to their corresponding cells in a worksheet when click a command button. Is there a quicker way to do so rather than writing a line for each control to force the blanket update? ... (assuming every control is "linked" to each cell)... try "blanking" (in one step) "their corresponding cells" -?- if any doubts (or further information)... would you please comment ? regards, hector. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I blanket update all controls inside a frame?
hi, Sam !
The controls are linked to cells (with their ControlSource set to the cells). The problem I had was that when the worksheet updates, not all these controls update to reflect the changed value. So what I do now is to code each control's value to its corresponding cell in the subroutine CommandButton_Click(). This ensures all controls always show their linked cells value in real time when click the button, and it's working fine. I just wonder if there's an easier way to refresh multiple form controls without referring to the worksheet in the code like I did (as the form controls already have their ControlSource specified in property)? I'm not so sure I'm following you quite accurately -?- I used a form with one textbox, one combobox and one checkbox (one commandbutton for "other" purposes) (controlsource are A1, B1 and C1 respectively) when I use each control, it's cell (controlsource) updates accordingly when I click the userform, code "blanks" the range (A1:C1] and controls refresh to show the (new) data in their cells when I click on a commandbutton, code "puts" data in source cells (obviously, controls do reflect this changes) here is what I used in userform code-module: Private Sub CommandButton1_Click() [a1:c1] = Array("Test text", "Name 03", False) End Sub Private Sub UserForm_Click() [a1:c1].ClearContents End Sub hth, hector. __ previous posts __ I have several controls (i.e. textbox, combobox and checkbox) inside a frame in a form and need ALL their values to update to their corresponding cells in a worksheet when click a command button. Is there a quicker way to do so rather than writing a line for each control to force the blanket update? ... (assuming every control is "linked" to each cell)... try "blanking" (in one step) "their corresponding cells" -?- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to access all the textboxes inside a frame? | Excel Programming | |||
frame control inside an image control | Excel Programming | |||
MultiPage: How to enable controls in Frame on Page | Excel Programming | |||
Controls in a Frame | Excel Programming | |||
Creating Userform Controls on Frame | Excel Programming |