Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

Programmatically creating Excel VBA validation list -


i have array of data coming in vba code external source. want able assign data use validation in dropdown box in cell in 1 of sheets in workbook. however, not want copy data sheet , use named range - there may quite lot of data, , not feel efficient!

i'm sure there must way - haven't found 1 yet. ideas?

  1. place data in text file delimiting comma eg(a,b,c).

  2. read data using vba string variable eg validationlist.

  3. use thing this

    with range("a1").validation
    .add type:=xlvalidatelist, alertstyle:=xlvalidalertstop, operator:= _
    xlbetween, formula1:=validationlist
    .ignoreblank = true
    .incelldropdown = true
    .inputtitle = ""
    .errortitle = ""
    .inputmessage = ""
    .errormessage = ""
    .showinput = true
    .showerror = true
    end with


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -