Search results for query: *

The RANK() function Help says the REF argument can be an array. However, I can find no way to make it accept anything except a reference to a worksheet Range. For example, the ARRAY() function causes an error. Has anyone out there been able to make it work with anything other than a Range? TIA...

A user asked me: " would like to visually link items in two list boxes similar to the way the QBE interface in MS Access works. Does anyone have any ideas on how to do this?" In other words, 2 list boxes connected by a line which links a single item in one list with a related item in...

Anybody know if there is any way to capture the pressing of the <alt> key in Excel 2k VBA the way you can in VB using the KeyPreview event? Thanks in advance!

In Access 2k, trying to do an incremental search of an already-populated (and sorted) multiselect list box using a text box for the criteria. want to cause the list box to scroll to the first item that matches the characters in the text box. works when multiselect is set to none, but not when...

By default, the Access97/2000 querytimeout property is set to 60 seconds. Is there any way to change the DEFAULT value for ALL new queries? We know how to change it for individual queries thru the properties dialog in design mode, but that is not an acceptable alternative in our environment...

Is there a way to add a Tip Text to a Command Button on an Excel Worksheet (NOT on a button bar and NOT on a form - the button is directly on the worksheet)? Command buttons don't appear to have the ControlTipText property when used this way. Using Excel 2k, Office2k, Win2k

I recorded this but when I play it back, it fails with Runtime error '1004': 'PasteSpecial method of Range class failed'. I can't locate the xlDataValidation constant in my Object Browser, but all the other &quot;Paste:=&quot; constants show up. Is this a known bug in Excel? Any ideas? Anyone...

VB has a number of functions (IsDate, IsNumeric, etc.) to check a variable's type. I could not find one that checks to see if a variable is a Variant, so I wrote the one below. But is there a simpler approach? Function IsVariant(ByRef TestVar As Variant) As Boolean ' This assumes...