Search results for query: *

If you take a look here: http://www.j-walk.com/ss/excel/eee/eee002.txt you will find some code to make an Excel cell blink. You could use the same method to make a control on a form appear to flash but you will need to include a 'DoEvents' in the loop. Hope it helps Rog

How about this? GetMonthNumber = Month(DateValue("1 " & strMonth & " 2004")) Rog

Re Excel 97 on NT4 Before getting to: Worksheet.Printout is it possible for VBA to check that: 1. The current user has installed a printer on the PC 2. The printer is switched on Or is the only way to prevent this kind of error the use of an error trapper? Rog

The other way is to use the Date Time Picker control which ensures that the value is always a recognisable date. Cheers Rog

It's best to start with a basic list, with one row for each person. Show the age group in Col B and the skill level in Col C. Then you can make a pivot table to analyse your list showing the count. If you've not used pivot tables, you'll find the wizard quite straightforward to use. The...

Thanks Skip, it works a treat after some initial hiccups. For the benefit of anyone else wanting to do this in the future, the workbook being tested needs to be in the same instance of Excel as the code thats running otherwise it crashes with an automation error on the line For Each vbc In...

This relates to Excel 97. I am wanting to create a list of which of the numerous Excel files in a drive have code modules so that I can review them. The procedure I have written is looping happily through the directories and sub-directories, opening each xl file in turn. My method of...

If I understand your question . . . If you have 2 xl files open: Book1.xls & Book2.xls. Book2.xls has a sub called MainSub that you want to run from Book1. In your code in Book1, make sure that Book1 is activated. Then the following line will run Mainsub: Application.Run...

Thanks PH Having thought about the problem over the weekend and spent some time consulting the bottom of my glass, I'd come up with a similar conclusion as you, that it had to do with which was the active workbook. Unfortunately that didn't work, so rather than waste any more time I've taken...

This relates to Excel97 running on NT4. I have a VBA function I coded that is used in a number of worksheet cells. Its been working quite happily for the last couple of years. Coding for the function is in a normal module in the workbook it is used in. The workbook (call it wb1) is fairly...

Unfortunately I can't find the now obsolete system I used it on but if I remember correctly I overcame the click event hurdle by designing a form full of static controls and then hid those that weren't needed. If the number of controls needed was more than on the form I had some scroll type...

Going back to your original question, there's a method I have used successfully in the past but its more long winded than in VB. If you want an array of 10 CommandButtons, you name them cmd01 to cmd10. You can then loop through them as though they were an array: For Cntr = 1 to 10...

You can do it in Excel97 without having to resort to code. Select all sheets in the workbook and then do your find. Cheers Rog

Tools, Options, General, User Name in Excel97. No doubt similar in later versions.

Try checking your paper size settings. It can be caused by printer settings 'Letter' and putting A4 paper in the printer. Roger

InputBox returns a string even when the user enters a number. You can try this: varcasenumber = CInt(InputBox("Enter SLO#")) but if the user enters something that can't be converted to an integer, it will crash. Take a look in your help files about using IsNumber before attempting to...

Craig If you have more than one workbook open, you can scroll through them using: ActiveWindow.ActivateNext If there's only the one workbook open, the activeworkbook remains the same. Hope it helps Roger

If I understand the problem correctly then a number of conditional sum formulas might do the trick. If you've never used one, go to Tools > AddIns and install the Conditional Sum Wizard then go to Tools > Wizards > Conditional Sum to run it. Make sure that the ranges you use include sufficient...

Hi All I've been following this saga with lots of interest. Rolf You could try the following as a partial solution for an Excel file with a header: In the Workbook_Close event coding 1 Save the workbook (as an Excel file) 2 Remove headers 3 Insert new Row 1 on each worksheet 4 Enter same...

So the next thought is that it's too 'prettied up'. Excel 97 doesn't like too many different formats on a sheet. Try selecting a complete sheet and changing all formats to the same colour, with the same number and font format. If that opens OK get the user to re-format the sheet, formatting by...