Display current time on a form in a Mac

[Aussiebear]

Can one display the current time on a form within Mac Excel?

[SamT]

IF you can display on a worksheet on a Mac, you should be able to do it on a form. In both cases. It is just a text string. and all standard Form controls display text either as a String value or a Variant Value.

[Aussiebear]

Don't know if that is possible Sam. I've spent the last few hours searching the internet and they talk about putting a time in a worksheet but not a form.

[Paul_Hossler]

I would expect that the WS formula NOW() would recalculate whenever the WB was recalculated, but a UF string that was initially set would not automatically update

You should be able to grab the time and put it on the UF when you .Activate it, but you would have to manually cause it to update (via .OnTime??)

No Mac to experiment with

[SamT]

Are you asking for a digital clock kinda thingy?

[filipebessa9]

Hi everyone, Im so sorry for asking here but I don't seem to actually be able to create a post, how does that work?

It keeps coming up with a message about URL's etc...

[SamT]

One has to have at least 5 posts to use URL.s and atachments. You need to use the Go Advanced Editor to attach files.

You can post your code by clicking the # icon on the editor, then Copy and Paste your code between the CODE tags

[Aussiebear]

Yes Sam a digital clock is preferred.

[SamT]

Here's seven. Take your pick.

[Aussiebear]

Thank you Sam

[Aussiebear]

I would expect that the WS formula NOW() would recalculate whenever the WB was recalculated, but a UF string that was initially set would not automatically update

You should be able to grab the time and put it on the UF when you .Activate it, but you would have to manually cause it to update (via .OnTime??)

No Mac to experiment with

All I am chasing is the current system time.....

[Aflatoon]

Do you want it updating in real time? (if so, what precision - minutes? Seconds?)

[Aussiebear]

Minutes only. it will form part of the main screen so the operator will see day of week, actual date and the time.

[Aflatoon]

I think the only way you can do it is with DoEvents in a loop (OnTime won't run):

private sub userform_activate()
runtimer
end sub

sub runtimer()
do
doevents
me.label1.caption = now
doevents
loop
end sub

[SamT]

OnTime won't run on a Mac? I have PC, so can't know.

Didyou pout the OnTime sub in a module and call it from the Form? I had to do that one the Clock I built in
Calculate hours.

[Aflatoon]

I know.

OnTime won't run because the form is loaded. (and you can't load it modelessly on a Mac).

[SamT]

Do you mean that you can't call a standard module procedure with OnTime on a Mac if a UserForm is Loaded?

Can you Load two Forms at the same time?

[Aflatoon]

Do you mean that you can't call a standard module procedure with OnTime on a Mac if a UserForm is Loaded?

Yes.

Can you Load two Forms at the same time?

Yes you can.

[SamT]

That makes a difference. Maybe we ought to get Aussie a PC laptop for Christmas.

[Aussiebear]

I've passed the hat round here at home and all I got was a "No" from the bride.