Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA programmatic validation problem
Hi, newbie post here - I've trawled the archives and can't seem to fin
an answer to my problem. I'm using Win2000/Excel 2000/VB6 Basically I'm trying to add drop down list style validation to a cell. I believe this should be possible using the validation parameter of range: Range("e5").Validation.Add Type:=xlValidateList, _ AlertStyle:=xlValidAlertStop, _ Operator:=xlBetween, _ Formula1:=txt Where text is a comma separated string ("M,F" in this case) Every attempt to use validation in such a way gives the error "Run-Time error '1004': Application-defined or object-defined error". I've played with many variations on the above syntax, and the sam error message always results. Any ideas what I need to do to get this working? Might it be m references or something like that -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export filter - programmatic access to | Charts and Charting in Excel | |||
Programmatic Hiding | Excel Discussion (Misc queries) | |||
'Programmatic access to Visual Basic project is not trusted.' message | Excel Programming | |||
Excel Validation Problem in VB6 | Excel Programming | |||
"Programmatic Access to be Denied" displays when running macro on excel in XP | Excel Programming |