-
Apr 12th, 2005, 07:32 AM
#1
Thread Starter
Frenzied Member
over riding data validation in excel
Hello
I have this excel sheet set to accept certain values only through the data validation field set to accpt only these values only
1, 20, 35
however i seem to be able to set the values through VB by unprotecting the sheet.
when i go back to excel, the value say 60.001 is there, however, data validation still says i can only have 1,20 or 35
is my vaue 60.001 written to the cell valid or does it have limitations?
-
Apr 12th, 2005, 01:11 PM
#2
Re: over riding data validation in excel
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it!
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
-
Apr 13th, 2005, 04:54 AM
#3
Thread Starter
Frenzied Member
Re: over riding data validation in excel
Code:
XLsheet(FOO).Worksheets("budget").Cells(5, 2) = foo1
i am trying to write a value to cell(5,2) determined by foo1,
however cell(5,2) has been data validated to accept two values 20 and 35,
if i directly try to write values to it using by opening the excel sheet, it throws up the error
the value you have entered is not valid. a user has restricted values that can be entered in to this cell, but if i use the above code, (i unprotect the sheet before using the above code and then protect it soon after), i can input any value i want to.
i was wondering that the value i input into the cell, does it have any restrictions
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|