Creating a userfriendly Excel input form

Creating a form in Excel is fairly easy, using the right options in Excel.

• enter a label
• select the field which should contain the input and unlock the field.
• Add a message to be displayed when the input field is selected:

• Deselect the gridlines in View:

• Protect the Sheet: allow Select unlocked fields only.

 

Now the sheet is ready for use.

Conditional Comment

With this NON scrip technique, the browser info can be detected.
on MSDN: http://msdn.microsoft.com/en-us/library/ms537512(VS.85).aspx
Also used to create WP7 optimized sites: http://blogs.msdn.com/b/iemobile/archive/2010/12/08/targeting-mobile-optimized-css-at-windows-phone-7.aspx