Search results for query: *

I put a Checkbox1 on Userform1 and the code recognizes it. Later, I put Checkbox2 on the same form, but the code does not see Checkbox2, only Checkbox1. any ideas? Win2k/Office2k Harold

I wrote a VBA app in Excel2000 that I want to use in Excel97. Upon reaching Worksheets("temp").Copy an error is generated that says the method is invalid. I also noticed that when I do Worksheets. without anything after the dot, I am prompted with a list of possibilities, but if I add...

What is the equivalent of Worksheets("temp").Copy in the 97 version?

when I copy a sheet to another workbook (via VBA, or course) how can i drop any VBA code imbedded in the sheet? Specifically, I don't want a user to encounter the macro message when opening the resulting new file. Thanks, Harold

I have a function that looks at a list of numbers, and I want to use .Cells(xlDown) to get to the bottom of the range. When there is only one item, the xlDown goes to the bottom of the sheet. Then if I do a "For each c in ..." it takes a while. What is an easy way to prevent that...

I wrote an application using Excel2000 and I want to use it on Excel97. It saves sheets of a workbook as separate files. It works on my computer but on another computer I get the error that the class is invalid. Why would that be? Harold

I want a form to load or macro to run when a certain workbook is opened - like autorun. I open it from Excel (not from another VBA app). How do I do it? Thanks, Harold

I'm running Excel 97 on NT4. My VBA does not recognize the clipboard or printer objects. Eg., I can't set printer properties. why not? Thanks.