Replies

Just curious… what is the significance of the brackets [ ] around the h?

(Edited by Don_Sadler on 12-Jul-03 20:58. Operator error – I now have it.)

Okay – I agree with all about the personal.xls – however, I can’t find mine. I am using excel xp (2002) and I have searched all over my hard drive for hidden files, system files, etc and no personal.xls. I do have add-ins, global macros, etc so I must have a personal.xls. Is there another name for this file? Never mind – I guess I didn’t have any global macros.. I have now and I do have the personal.xls.

Funny what I learn from Woody’s Lounge. I just learned that apparently there is a difference between the European & US versions of Excel in how formulas are delimited. I pasted the above formula [=IF(B2=1;”

(Edited by Don_Sadler on 08-Jul-03 11:28. Didn’t see the Choose function initially.)

Thanks Steve, that does work, of course. I like the “choose” option.

Okay, I see your point. That brings up another question, though. What is the convention for describing these types of data? Interesting discussion on several levels.

As I see his diagram, the numbers are correct and add correctly. I don’t understand where you get

Total A = 419+80 +138+53 = 690
Total B =171+80 + 87+53 =391
Total C = 246+138+87+53 = 524

Total number = 1194

But, I am no math person so I may be wrong. Anyway, I also found that if you turn off the auto format, you can resize and reposition the circles to get the effect you want (see attached). I don’t know if this can be done automatically based on some data series.

Thanks – it does work, of course. I don’t understand why or how. I could not help but notice that your post was edited to put in an improved, simpler formula. All I can say is, this is absolutely not simple. Maybe improved but not simple. Thanks again.

Thank you, I will try it. In the meantime, I have found that if i insert a space into the existing text box, I get what I want – the appearance of no text box and the timeplus appears on mouseover.

Also, regarding the screen flash as it exits the slide show – did you try “application.screenupdating = false” ?

Catharine,

I got the macro working fine now after adjusting the security settings. I have also adjusted it to show only the hour and second. Is it possible to do things more with this macro? 1) have the text box appear blank initially and/or 2) have the macro run automatically when the slide is displayed?

I also have a couple of questions about your code – I am new at VBA and trying to learn. When you wrote “CurSecond = Second(Time)” I understand that Cursecond is a variable you defined but where is Second(Time)? I looked in VBA help and couldn’t find it. Is it a reference to system time? Where would I look in Help to find it?

that was the problem – security setting. It was on high, I changed it to medium and all works very well now.

I don’t understand why I am unable to runa Macro in PPT. This is the first time I’ve tried so I am sure that there is something I am missing. I created my own using the followng code:

Sub timeshow()

Dim MyTime
MyTime = Time
With Application.ActivePresentation.Slides(1)
MsgBox (MyTime)
End With
End Sub

It doesn’t work either and oddly, when I go to the macro window (in tools), the run command is grayed out.

Thanks Catharine, This concept is even better than linking it to excel. Regrettably, however, the macro doesn’t seem to work for me. It displays a slide with a text box containing 2:13:00 AM and there seems to be no way to update it. BTW, my current time is 6:29:00 AM. When I try to run the macro, the run command is grayed out. When I display this slide in a slideshow, my cursor chages to a hand when I move overt he time yet there is no time update, even if i click. Maybe i am doing something wrong?

Any ideas?

Thank you Hans, perfect explanation. I understand now.

Okay, I found the answer. I don’t understand why or how it works but it does work. if anyone can explain it, I would appreciate it. I found the answer on John Walkenbach’s page (http://j-walk.com/ss/excel/tips/tip74.htm%5B/url%5D ). His tip said.. and I quote

Count of Sales where Month=”Jan” AND Region=”North”
For multiple criteria in different fields, the COUNTIF function doesn’t work. However, you can use an array formula. When you enter this formula, use Ctrl+Shift+Enter:

=SUM((A2:A10=”Jan”)*(B2:B10=”North”))

————
I just substituted appropriate ranges and criteria.

Regrettably. no. Access is not an option. I have found a way to do it although not very elegant by using a combination of COUNTIF and OFFSET. I just thought there must be a better method. Maybe even using an array of some type.