Refresh userform periodically

Hi everyone,

I was wondering how i could refresh a userform every every 3 seconds or so?

I'm using

Please Login or Register  to view this content.

within the userform_activate module?

am i pi55in in the wind with that one?

Cheers

Hey Magoo, nice 1337.

I worry about your eyesight and a userform model or not model. It always happen to me that when a userform is showing, I can't do much else but work on it. If you do a refresh, is it because something on the sheet is changing? I don't think that can happen while the userform is displayed. I may be wrong with a modeless userform.

Look at the section in http://www.tushar-mehta.com/publish_...rinterface.htm titled A userform design model for forms shown modeless It may help answer your question.

Hi Marv,

OK bit confused lol, Whats a 1337? also why the eyesight ref?

Anyway back to the point , I have created a mini "Chat app" in a userform that works by sending the messages to a access DB and also reading from the DB. I need to refresh the form every so often to update any new messages.

I have a refresh button that works fine but i would prefer not to have to refresh it manually.

any ideas?

not sure that link helped much buddy?

Cheers

Is your form modal or modeless?

answer: userform1.show 0

Bump?! any ideas folks?

You could use something akin to this

In a normal module

Please Login or Register  to view this content.

Userform code:

Please Login or Register  to view this content.

Why don't you use the double_click event or any other event to refresh the data ?
You didn't mention any periodicity in refreshing.

I don't want the user to have to refresh it that's why mate

keep it simple

In the useform:

Please Login or Register  to view this content.

In the 'thisworkbook' module

Please Login or Register  to view this content.

Replace 'MsgBox "cccc"' by your refreshing code, 'mate'.

Hi Mr. Magoo,

OK bit confused lol, Whats a 1337? also why the eyesight ref?

1. You wrote pi55ed-off which uses numbers for similar shaped letters. This is called LEET spelling or 1337 converted.
2. Mr Magoo was one of my favorite cartoon, the blind old guy, along with Marvin the Martian.

I see that others have jumped into the answer. I'll read what they say in a minute after my very early morning coffee. (It's 5 am here!)