Search results for query: *

Got it! I had 3 radio buttons that were grouped. I added a fourth and forgot to include it in the group. Once I fixed that, the checkbox problem fixed itself. Who knows why? I don't - but it works now.

oops - forgot to add, The code is all on Userform1. I tried deleting the control and adding it again. Didn't work.

The control is visible on the form. The name is the default (Checkbox2). When I type 'Checkbox2.' nothing happens. If i do the same for 'Checkbox1.', I get the shortcut list. Also, when I type 'Userform1.' the shortcut list includes everything else on the form, including Checkbox1, but not...

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

Thank you both. Now it works.

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

How do I access the clipboard from VBA?

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.