if any one could look at this (the set up, code, user friendliness, etc...) and give me some suggestions it'd be greatly appreciated. it is going to be sent out many many times. It is going to be sent out by email. I eventually want to incorporate email into this to return the "Submit" sheet, but have not quite figured that out. I also had to remove the "printable sheet" due to size.
Thanks.
It's looking pretty good but still has a few problems...
I would change for starters:
textAdditionalComments
Change multiline property to true
I would change this to printpreview for testing:
[VBA]
Worksheets("PrintableForm").PrintOut
[/VBA]
to this:
[VBA]Worksheets("PrintableForm").PrintPreview[/VBA]
All sheets except the front can be hidden....sure there is more but it's getting there and will be much cleaner than printing forms...
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
thanks. yeah i do intend hiding everything except for the first one....just left it all visible for the review purpose. the printpreview is a good idea.
oh yeah....when you opened it and go to the last page...were ALL of the values marked?
Both of the data sheets seem to match.....was wondering why your using 2 sheets for this?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
I am toying with maybe eliminating some fields for the Submit sheet. Example: I do not need to have both MissionCriticalYES and MissionCriticalNO for my use (i can tell if that if YES is False then the answer is No), but for the saving/reloading purpose i need it to recognize the value for both option buttons.
Why not just use one sheet populated from the form and then populate the other sheets from there with whatever you want?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
