wolf.stalker
04-26-2008, 01:39 AM
hi all and thanks for any help you can provide.
i have a spreasheet that has 18 headers (or columns) that contain data. some of these contain formula's, others are validated by a drop down list. example.....G1 limits user to color Red Blue Black only. and so on.
all works fine here.
now, as my information goes way off the monitor screen, i had thought about using the default form that xl provides. i even got it to launch on a workbook_open() event but there is one small issue. it creates all the hearders and fields but does NOT include the validation. anyone have any idea if this can be done with the defualt form?
closest thing i could find was this when digging around online. course i think he built his from scratch.
http://www.j-walk.com/ss/dataform/index.htm
i have a spreasheet that has 18 headers (or columns) that contain data. some of these contain formula's, others are validated by a drop down list. example.....G1 limits user to color Red Blue Black only. and so on.
all works fine here.
now, as my information goes way off the monitor screen, i had thought about using the default form that xl provides. i even got it to launch on a workbook_open() event but there is one small issue. it creates all the hearders and fields but does NOT include the validation. anyone have any idea if this can be done with the defualt form?
closest thing i could find was this when digging around online. course i think he built his from scratch.
http://www.j-walk.com/ss/dataform/index.htm