PDA

View Full Version : Doevent and buttons



s.dinah
11-07-2018, 06:24 AM
Hi,

So I have created this macro that creates a query table an refreshes it every second. I have 2 button to "connect" and "disconnect".

"Connect" runs the code.

The code runs alright and the query table get refreshed accordingly however the buttons are no longer visible! I tried changing the sleep time an the position of doevents but it does not appear make any difference.

Any ideas as to how I can resolve this issue?

ps is there maybe an alternative to use doevents?