Unable to clear the contents of Datavalidation in excel using VBA -


i have vba function bind array excel range , in turn use range specify data validation list selected range.

below function create datavalidation list. 

private function createdatavalidation(byval pobjrange range, byval pvararrayentries variant) boolean  const picklist_column = "iv"  createdatavalidation = true   if ubound(pvararrayentries) = 0     pobjrange.validation.delete else     '     ' select range     '     dim lobjpicklistrange range     set lobjpicklistrange = application.activesheet.range(cells(1, picklist_column), cells(ubound(pvararrayentries) + 1, picklist_column))     '     ' clear existing column     '     lobjpicklistrange.clear     '     ' write entries picklist column     '     lobjpicklistrange = pvararrayentries      dim lstrformula string     lstrformula = "=" & picklist_column & "1:" & picklist_column & ubound(pvararrayentries) + 1      if application.referencestyle = xlr1c1         lstrformula = application.convertformula(lstrformula, xla1, xlr1c1)     end if      pobjrange.validation         .delete         .add type:=xlvalidatelist, alertstyle:=xlvalidalertstop, operator:= _         xlbetween, formula1:=lstrformula         .ignoreblank = true         .incelldropdown = true         .inputtitle = ""         .errortitle = ""         .inputmessage = ""         .errormessage = ""         .showinput = true         .showerror = true     end  end if

end function

issue that, when bind range array values drop down appears, when select same range , pass empty array above method drop down doesn't disappear. means code in function 

if ubound(pvararrayentries) = 0     pobjrange.validation.delete

doesn't work. in clearing range contains datavalidation drop down of great help. tried range.clearcontents , validation.delete nothing worked.

for information,the above function called on workbook_sheetselectionchange event

thanks in advance.

i find workaround problem, setting incelldropdown false, way if array has no elements, setting above property false drop down not visible , user not able set value. inputs.


Comments

Post a Comment

Popular posts from this blog

android - Pass an Serializable object in AIDL -

i have defined aidl file interface imyfeature { void dotask(class clazz); } but need pass class object process. possible in android? if so, how? i tried: interface imyfeature { serializable class; void dotask(class clazz); } but doesn’t work. aidl in android supports custom class implement parcelable interface. in case want send class object not possible. can send class canonical name , retrieve in service. for example have aidl file interface imyfeature { void dotask(string classname); } then call : binder.dotask(myclass.class.getcanonicalname()); and in service binder stub implementation : private final imyfeature mbinder = new imyfeature.stub() { public void dotask(string classname) { try { class<?> clazz = class.forname(classname); constructor<?> ctor = clazz.getconstructor((class[]) null); object object = ctor.newinstance(); ...
Read more

How to provide Authorization & Authentication using Asp.net, C#? -

Image
i have asp.net application in c#. i have provide page authorization specific user/usergroup. i have created 2 tables in database: 1) pagename 2)permissions[insert, update, view, delete] but i'm unable match tables , permissions assigning... can 1 please me, how created tables in database , how coding. please me. you can below explanation. configure access specific file , folder, set forms-based authentication. request page in application redirected logon.aspx automatically. in web.config file, type or paste following code. this code grants users access default1.aspx page , subdir1 folder . <configuration> <system.web> <authentication mode="forms" > <forms loginurl="login.aspx" name=".aspnetauth" protection="none" path="/" timeout="20" > </forms> </authentication> <!-- section denies access files in...
Read more

How to use Authorization & Authentication in Asp.net, C#? -

i using roll management , trying give page , folder access according user or user group, using server created ad group user authentication. i have default1.aspx page default , subdir1 folder give different access separate user group i using below logic in web.config. <location path="subdir1"> <system.web> <authorization> <allow users ="?" /> </authorization> </system.web> </location> i facing problem provide same access 2 or more directory same user should have provide allow user code twice both folder? i can use logic repeating value folder want access providing in 1 logic. i have got answer configure folder/page access, have make different access shown below.. configure access specific file , folder, set forms-based authentication. request page in application redirected logon.aspx automatically. in web.config file, done following code. this code grants user...
Read more