Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an AfterUpdate event for excel combobox?
I have an excel 2003 combobox. I need an "after update" event likeI know
from Access. Is it available in excel? When I look into events in the vba code I have "click" event and "change" event available. The change event fires when I move from one item to the next in the drop-down list. The click event fires when there is a match in the drop-down list, for instance when I type the letter D to scroll down dropdown list to list items starting with letter D. None of the events seem to do the job for me. What I need is to detect the contents of the combobox after the selection is done by the operator and the dropdown list is collapsed. How can I fix this? Regards Tore |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an AfterUpdate event for excel combobox?
Yes, if the combobox is in a userform. The event is provided by the control
object which is the container on a userform. On a worksheet the container is the oleObject which provides gotfocus and lostfocus, but not afterupdate. -- Regards, Tom Ogilvy "T.G." wrote in message ... I have an excel 2003 combobox. I need an "after update" event likeI know from Access. Is it available in excel? When I look into events in the vba code I have "click" event and "change" event available. The change event fires when I move from one item to the next in the drop-down list. The click event fires when there is a match in the drop-down list, for instance when I type the letter D to scroll down dropdown list to list items starting with letter D. None of the events seem to do the job for me. What I need is to detect the contents of the combobox after the selection is done by the operator and the dropdown list is collapsed. How can I fix this? Regards Tore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Trigger copy on AfterUpdate event | Excel Programming | |||
PivotField AfterUpdate event? | Excel Programming | |||
AfterUpdate Event not Running | Excel Programming | |||
Excel 2000 ComboBox Code Change event | Excel Programming |