Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating userform
2 part question:
a. What events should I be using to update between my userform and worksheet? Is it ever good practice to use the ControlSource property for say a textbox? b. How can I validate multiple textbox's with the same code? For example: Private Sub TextBox1_Change() Call Update End Sub Private Sub TextBox2_Change() Call Update End Sub In Sub Update(), how do I reference which text box changed? thanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating userform
The ActiveControl object will always reference the control that is currently
active. Since your Sub is being called from a control's event procedure, then that control must currently be active, so ActiveControl will be referencing it. Rick "steve" wrote in message ... 2 part question: a. What events should I be using to update between my userform and worksheet? Is it ever good practice to use the ControlSource property for say a textbox? b. How can I validate multiple textbox's with the same code? For example: Private Sub TextBox1_Change() Call Update End Sub Private Sub TextBox2_Change() Call Update End Sub In Sub Update(), how do I reference which text box changed? thanks, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating userform
Maybe start he
http://www.excel-vba.com/excel-vba-contents.htm "steve" wrote: 2 part question: a. What events should I be using to update between my userform and worksheet? Is it ever good practice to use the ControlSource property for say a textbox? b. How can I validate multiple textbox's with the same code? For example: Private Sub TextBox1_Change() Call Update End Sub Private Sub TextBox2_Change() Call Update End Sub In Sub Update(), how do I reference which text box changed? thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform for updating records | Excel Discussion (Misc queries) | |||
Help !, problem updating data through userform ! | Excel Programming | |||
Userform updating via spinbutton | Excel Programming | |||
Userform updating | Excel Programming | |||
Updating .tag in Userform Control in VBA | Excel Programming |