Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you very much Bob. You instructions have been followed and the
problem has been resolved. Apart from the problem itself, I would also rather figure out (and hopefully learn) a bit more on what I did not and do not know... In terms of immediate window, I searched Excel help facility for it but did not get much insights at all. So basically, when should I use an immediate window and what can it do besides enabling events? Regarding general macro programming, should I always run 'Application.EnableEvents = True' in the immediate window to make sure events are enabled? I thought they are enabled as default. Does the event invocation command work at workbook or excel level? I have adapted your code(thanks again) in my case, which when EITHER a user selects an option from a dropdown list OR certain cell, say A10, loses focus, an event handler will assess the situation to determine population of B10. In case of focus change in A10, it also acts differently in accordance with the current entry from the dropdown list. So such an event handler is associated with both the dropdown list and focus change(placed at the sheet level), to make sure both behaviours can be captured. I am not sure whether it's a smart move but it simply does the job as far as I can see from now. Thanks again Bob for your kind help and best regards! Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming |