I can't wrap my head around this. I have a userform that will resize frames and listboxes based on the number files in the folder. However the resize doesn't work unless I input either 'DoEvents' or 'Wait' into the code.
The code is in the form and not in a separate module.
I need assistance in creating a formula to determine the average wait time for numbers greater than or equal to 200000 to appear in a series.
I have 100 lines of data (BJ100:BJ200)
The wait time will be determine by the row number,eg
it is my understanding that using application. Wait will only work for durations of 1 second or more
I need a way of waiting either 3 milliseconds or more up to about 50 milliseconds for one function I need to perform and up to as much as 500 millisecons (i.e. half a second) for another...
I have a NAMES DRAW from a HAT worksheet. Names as selected from a list using RND. These names tick over in a cell. I had hoped to progressively increase the speed of the draw to the final winner - like a ham wheel.
I am using a WAIT macros
Application.Wait (Now + 0.000006)
This is used in...
Am I doing it correctly ?
x = Shell("D:\A-Sides\doit.bat", vbNormalFocus)
'wait for bat to finish
Application.Wait (Now + TimeValue("0:00:10"))
The wait is working but Doit.bat doesn't run. Is something else needed?
Good morning! I'm trying to create a loop that operates with a specified date range and interacts with host explorer. I need it to advance the start date by one until it goes past the end date and then stop. Here was my first go at it, but stepping through eventually led to a "Run-time error...
The status bar looks like it is in two halves ? or am i wrong (i can see a dividing line)
I can put a message in the first part by
Application.StatusBar = ("Updating Sheet Data Please Wait")
i am wanting to put a status of something in the second half is this possible how?
I am creating some script in workbook "A" that allows me to open workbook "B" from the internet and paste the contents of workbook "B" into workbook "A". The problem I am running into is workbook "B" is staying open, so when the script reruns it pastes from workbook "C" into workbook "B"...
For example, I'm on yelp and search for 'burgers' in 'maine'
I have a for loop to scrape each of the 10 results and then click the link to get the next 10, until page 5 (so 50 results in total)
I run into a problem at number 11 (where page 2) would start.
I think a the source of the...
I have an Auto_Open macro that cleans up data before allowing the user to begin. This only takes around 8 seconds, but I wanted to put a message asking the user to please wait a moment while we tidy things up.
What I found is that when I start my Auto_Open macro with MsgBox("Please wait a...
I have a please wait message that appears if there is no other action in the sub but refuses to show if the sub calls another sub??
What's wrong with my code please
Public Sub MultipleProcessCheck_onAction(control As IRibbonControl)
' Button 53
' Please wait message...
Dim FilePath As String
Dim strFilename As String
Dim strTextLine As String
Dim iFile As Integer: iFile = FreeFile
strFilename = "C:\desktop\file.txt"
Open strFilename For Input As #iFile 'read each line in text individually
Application.Wait (Now + 0.0000058) 'wait for about...
hi the following works other than the red code doesn't wait until reached zero, I want it to wait until timer finished, can you help please
Application.Wait (Now + TimeValue("0:00:05"))...
Good evening Excel Legends,
I am trying to apply conditional formatting to a column in Excel using the "Use a formula to determine which cells to format" feature.
In DATA sheet have a list of names in column A with corresponding reference numbers in column B and type in column C. In DATA...
Hi Experts - I have below code as part of the workbook i am creating.. everything is working fine, except that when i am trying to divide the column by 1000000, it always turn zero after the macro is finished running. But when i run the code line by line (pressing F8), it is working properly...
Hi there. I have a picture that I am changing based on the result of a formula. I have a hidden sheet with all of the possible pictures sitting in cells and this part is working fine. But all of the pictures are different sizes so I am trying to run a macro to rescale the picture after the...
I am looking for VBA code sample for the following situation....
My excel code currently does a REFRESH ALL DATA. At which point in the lower left is displayed the message, "RUNNING BACKGROUND QUERY ... (CLICK HERE TO CANCEL)". Also later at times when I refresh, I get a message...
I have created a spreadsheet that takes information exported from another program and prints out different worksheets based on the information from the export. I use this spreadsheet multiple times a day and am looking to make a short key to bypass the steps required in actually...