About Us

TBD

Greetings,
I've written this question twice, and was about to abort it for the
second time, but will post it for comments, even though the problem may be
solved.

Note that below, the first string element of gNameAbbrs() had a leading '!'
(exclamation mark), and removing it _seems_ to have made a difference!(?)

(the original question)
I don't understand why the the code below doesn't work. After it
executes, the affected cell does not allow for a pull-down list - even though
the list DOES appear in Data\Validation dialog for the cell! Excel (2002)
also starts acting strange and will no longer quit via File\Exit Or the
window-close button - in either case a pop-up dialog announces that Excel
can't be exited. Killing Excel via TaskMgr is effective.

I've quintuple-checked the gNameAbbrs array (of Strings) is correctly
populated, again, the values ARE showing-up in Data\Validation UI.

Code:

           rRange.Select
           With Selection.Validation
             .Delete
             .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, 
Operator:= _
               xlBetween, Formula1:=Join(gNameAbbrs, ",") 'this isn't working
              'xlBetween , Formula1:="a,b,c" 'this works
             .InCellDropdown = True
             .InputMessage = ""
           End With

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation trouble	Bbongo8	Excel Programming	1	January 8th 12 02:10 PM
data validation trouble	copercar	Excel Programming	0	May 15th 08 03:50 PM
Formula1 Property of Validation Object to refer to function name	[email protected]	Excel Programming	2	March 30th 06 12:53 AM
Trouble with validation	funkymonkUK[_27_]	Excel Programming	11	June 17th 05 02:54 PM

Menu

About Us