LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default Conditional formula and a bit more...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM
Formula, Conditional Formula Needed Karl Excel Discussion (Misc queries) 12 June 23rd 07 04:12 AM
Conditional Formula to indicate Formula in cell SteveW New Users to Excel 9 August 2nd 06 01:12 AM
Multiple conditional on conditional format formula Frank Kabel Excel Programming 1 July 27th 04 06:24 PM
Multiple conditional on conditional format formula Bob Phillips[_7_] Excel Programming 0 July 27th 04 05:30 PM


All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"