Search results for query: *

I have a controlbutton object attached to a menu. The OnAction property works well if I do a straight call to a Sub procedure. However, I have a different Sub procedure that takes arguments. When I try to place 'Call ' in front of the Sub name in the OnAction property, the macro is not found. Is...

I'm trying to refer to a member of a collection by using a statement for the index. Specifically, I want to move through the controls on a form by using their TabIndex properties, rather than the collection index. I've tried: For i = 1 to Controls.count Controls(TabIndex = i).Select 'do...

I'm writing a macro in Word that needs to be able to run in Word 97 and Word 2000. However, when it's run in 2000, I need to add a statement that 97 doesn't require. The problem is that the method I need in 2000 doesn't exist in 97 so when I run it in 97 it gives me a compile error "Method...

I sometimes experience problems trying to sort columns that contain numbers formatted as text. The sort either doesn't work at all or sorts in several blocks. I've made sure that there are no leading or trailing spaces or special characters. Any ideas?

In a function I'm writing, I need to find the number of open workbooks, but I want to exclude those that are hidden. Please help!<br> <br> Thanks<br> Barry

I can't find anything that tells how to pass a cell's value to the sheet's header. Is this possible?

I'm trying to format a row based on the value of a cell in one column. I have a column called &quot;Reason&quot; and I want rows to have a different format if the Reason column contains a particular value, such as &quot;days&quot;. I've tried the conditional formula: =reason=&quot;days&quot; but...