Click here to Skip to main content
15,900,461 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Why Data Visualization is important? Pin
Dave Kreskowiak26-Aug-20 10:51
mveDave Kreskowiak26-Aug-20 10:51 
QuestionLoop DataTable per assegnare valori alle rows non ci riesco Pin
Fabrizio Leoncini21-Aug-20 0:33
Fabrizio Leoncini21-Aug-20 0:33 
AnswerRe: Loop DataTable per assegnare valori alle rows non ci riesco Pin
Dave Kreskowiak21-Aug-20 6:28
mveDave Kreskowiak21-Aug-20 6:28 
GeneralRe: Loop DataTable per assegnare valori alle rows non ci riesco Pin
Fabrizio Leoncini21-Aug-20 21:31
Fabrizio Leoncini21-Aug-20 21:31 
GeneralRe: Loop DataTable per assegnare valori alle rows non ci riesco Pin
Eddy Vluggen22-Aug-20 10:01
professionalEddy Vluggen22-Aug-20 10:01 
GeneralRe: Loop DataTable per assegnare valori alle rows non ci riesco Pin
CHill6025-Aug-20 2:17
mveCHill6025-Aug-20 2:17 
GeneralRe: Loop DataTable per assegnare valori alle rows non ci riesco Pin
Eddy Vluggen25-Aug-20 15:19
professionalEddy Vluggen25-Aug-20 15:19 
QuestionExcel vba creating a timer through doevents Pin
Mat 25720-Aug-20 3:42
Mat 25720-Aug-20 3:42 
hello everyone.
i am try to draw up a simple timer into a userform. having red doevent command can fit this purpose, i wrote below code:

Option Explicit
Public Esci As Boolean
Private Sub CommandButton1_Click()
    Esci = True
End Sub

Private Sub UserForm_Activate()
Dim countdown As Integer, i As Integer
countdown = 10
Me.Label2.Caption = countdown
Stop '<----- to check macro running only
For i = 1 To 10
    VBA.DoEvents

    Application.Wait (Now + TimeValue("0:00:01"))
    countdown = countdown - 1
    Me.Label2.Caption = countdown
    If Esci = True Then
        MsgBox ("CIAOOOOO")
        Exit Sub
    End If
Next
End Sub


now, doevents should set the compiler to keep "listening" other routine running while executing for next loop.
however, even if i press commandbutto1 to change boolean variable "esci" from false to true and exit the routine, nothing happens and the loop end up regardless boolean value. what i wrong? thanks
AnswerRe: Excel vba creating a timer through doevents Pin
Dave Kreskowiak20-Aug-20 4:31
mveDave Kreskowiak20-Aug-20 4:31 
GeneralRe: Excel vba creating a timer through doevents Pin
Mat 25720-Aug-20 10:22
Mat 25720-Aug-20 10:22 
QuestionGridview RowUpdating not showing updated record in grid Pin
cmn219-Aug-20 2:58
cmn219-Aug-20 2:58 
AnswerRe: Gridview RowUpdating not showing updated record in grid Pin
Eddy Vluggen22-Aug-20 10:03
professionalEddy Vluggen22-Aug-20 10:03 
QuestionNArrange Pin
ChrisRaisin13-Aug-20 14:52
ChrisRaisin13-Aug-20 14:52 
AnswerRe: NArrange Pin
Dave Kreskowiak13-Aug-20 16:33
mveDave Kreskowiak13-Aug-20 16:33 
QuestionHow code to Print a Bit map image to pos printer via comport in VB6 Pin
Member 149097158-Aug-20 0:25
Member 149097158-Aug-20 0:25 
AnswerRe: How code to Print a Bit map image to pos printer via comport in VB6 Pin
Richard MacCutchan8-Aug-20 0:46
mveRichard MacCutchan8-Aug-20 0:46 
AnswerRe: How code to Print a Bit map image to pos printer via comport in VB6 Pin
Eddy Vluggen22-Aug-20 10:07
professionalEddy Vluggen22-Aug-20 10:07 
QuestionGeoreferencing Pin
Benniit7-Aug-20 20:50
Benniit7-Aug-20 20:50 
AnswerRe: Georeferencing Pin
OriginalGriff7-Aug-20 20:51
mveOriginalGriff7-Aug-20 20:51 
AnswerRe: Georeferencing Pin
Richard MacCutchan7-Aug-20 21:51
mveRichard MacCutchan7-Aug-20 21:51 
AnswerRe: Georeferencing Pin
Eddy Vluggen22-Aug-20 10:09
professionalEddy Vluggen22-Aug-20 10:09 
QuestionFile System Watcher for remote folders? Pin
ForeverSoftware6-Aug-20 3:47
ForeverSoftware6-Aug-20 3:47 
AnswerRe: File System Watcher for remote folders? Pin
Richard Deeming6-Aug-20 4:00
mveRichard Deeming6-Aug-20 4:00 
QuestionRunning VBA in Shared Mailboxes 365 Pin
Willie_n5-Aug-20 23:20
Willie_n5-Aug-20 23:20 
AnswerRe: Running VBA in Shared Mailboxes 365 Pin
CHill6014-Aug-20 1:38
mveCHill6014-Aug-20 1:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.