Recent content by jcrater

My company has done many of these suggestions (bowling, lunch, bar, etc), but in reality they don't do much for team building. What usually happens is that the teams are always the same: People naturally team up with those that they work closest with, so no intermingling occurs. I don't like...

Not sure what version of Excel you're using, but try Data->Validation (use a list of allowed values)

Put shorter text values or even numbers in the sheet code names and sort on those.

at the system prompt: DIR c:\my folder > dirlist.txt there are several switches you can use with the DIR command to control the format of the output.

What OS are you using? With Windows 2000, if you use the scheduled task wizard you cannot set the frequency to a more granular level than once/day until you click the finish tab. Once you do that, you'll have access to an "advanced" button on the Scheduled section of the form. From there you...

I don't think you put the code into a new module; add the code to the worksheet_change event.

Remove the semicolon in your Print statement. You might want to open your file and leave it open until all records are written to it.

Can we see some code? What are you counting and how is it started and stopped by your application?

from Excel help: To produce random integers in a given range, use this formula: Int((upperbound - lowerbound + 1) * Rnd + lowerbound) Here, upperbound is the highest number in the range, and lowerbound is the lowest number in the range. if you want a 4-digit number, wrap the result with the...

You can use named ranges and macro code, or it might be simpler just to use conditional formatting. If you want to go the macro route, here's the high-level logic: For each cell in range if cell.value = "ABC" then <change text font color> end if next cell

Try Application.Undo

1) Use the Sleep API function, or 2) something like: Dim dtmNow As Date dtmNow = Now() Do Until DateDiff("s", dtmNow, Now()) > 1 Loop

Why not compile your code as an EXE and create a scheduled task to execute it?

Try removing the semicolon. I know that MS Access always appends one to the end of each command in a query window, but I've never used it with DAO.

The "set" statement worked fine for me. I'm assuming that your listview is named correctly. I did get an imagelist error on the last statement.