On Sep 3, 9:36 am, "Alex K. Angelopoulos" <aka(at)mvps.org> wrote: It could still be a resources issue, but it looks to me like this particular application may be running into issues. Does it maintain connections with all instances of the scripts? I couldn't see their knowledgebase since they only open it to customers; you may need to explore that side of this though. It's definitely
Hi Roger, Suppose I want to use that code for ten cells in one worksheet. I have tried to do so but couldn't accomplish much. I have attached an example as well. http://www.freefilehosting.net/download/3ibkh thanks "karl" wrote: hi roger, thank you very much!! it works great. "Roger Govier" wrote: Hi Karl I was not thinking correctly. As
here we go Roger: http://www.freefilehosting.net/download/3hbeh thanks. "Roger Govier" wrote: Hi Karl We need an event to trigger the macro. From what you had said previously, the value in D4 is a formula, based upon entries in other cells Let me know what the formula is in D4, so I can see which cells it is dependent upon. -- Regards Roger Govier "karl"
Hi Roger, I must be doing something wrong. I hit alt f11 and pasted the code. the first sentence (Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)) is all red when i paste it. thanks. "Roger Govier" wrote: Hi Karl I now understand. You cannot use DV error box, unless it is applied to that cell. You could incorporate some VBA code to
It is a wsh popup thing. And while valid you say, vista does not do what you want it to do. ----------------------------------------------- I need to call it a "day". It is 4:05 in the morning. I am sorry, You should be able to get a vista user's experience on that, in particular this month. Hold on to that promise.. ------------------------------------------------- Someone