imej-clavier's articles:

Items(7) /1

To reduce the speed of execution of a program VBAEXCEL 3 22 (3/18/2007 9:30:13 AM) comp.lang.basic.visual.misc Hello, I have made a program which circulates in a range of cells. I would like to reduce the speed of execution. I would like that the selection of the cells don't go so quickly. Is it possible and what must ... JeanMickey

Even or uneven numbers 9 34 (2/11/2007 4:29:31 PM) comp.lang.basic.visual.misc Hello, Is it possible to use or to create a function who gives a result of True or False for even or uneven numbers ? Thank you in advance, Jean-michel ... JeanMickey

Full path of a file existing in the computer 1 23 (1/18/2007 5:51:20 PM) comp.lang.basic.visual.misc Hello, Is there a way to find by programmation the full path of a file such as "MyFile.xls" for example (supposing it exists in the computer) ? Thank you in advance, ... JeanMickey

code to stop an infinite loop 8 32 (12/29/2006 6:02:29 PM) comp.lang.basic.visual.misc Hello, Could somebody give me the code for Ctrl + Pause or the way to stop with code an infinite loop in a CommandButton. Thank you in advance Jean-michel ... JeanMickey

Attempt to get a two dimensions array with a personnalized type 2 35 (11/21/2006 10:05:21 PM) comp.lang.basic.visual.misc Hello, I would like to create an array with two dimensions whose would be with a personnalized type (Type Z ...End Type). I have tried, unsuccessfully to use this way to declare the array : Dim TabX(1 To 4, 1 T... JeanMickey

Permanent working of the clock in a CommandButton in VBA for Excel 1 23 (11/12/2006 4:56:25 PM) comp.lang.basic.visual.misc Hello, Could somebody know how I must do to have the time displayed on a CommandButton (if it's possible) ? I have already obtained it with the following instructions (in the event Initialize of a UserForm) : ... JeanMickey

How works a progress indicator in Visual Basic for Excel 3 29 (10/24/2006 2:27:19 PM) comp.lang.basic.visual.misc Hello, I would like to make progress from 0% to 100% a progression indicator in the same time as the following instruction: Application.Wait(Now + TimeValue(0:00:10)) So, I would like to make progress my ind... JeanMickey

imej-clavier's replies:

Items(2) /1

How works a progress indicator in Visual Basic for Excel 3 29 (10/24/2006 2:27:19 PM) comp.lang.basic.visual.misc Hello, I would like to make progress from 0% to 100% a progression indicator in the same time as the following instruction: Application.Wait(Now + TimeValue(0:00:10)) So, I would like to make progress my ind... imej-clavier (9)

code to stop an infinite loop 8 32 (12/29/2006 6:02:29 PM) comp.lang.basic.visual.misc Hello, Could somebody give me the code for Ctrl + Pause or the way to stop with code an infinite loop in a CommandButton. Thank you in advance Jean-michel ... imej-clavier (9)