Display,mail record in existing user form

Hi,

I need you help in a userform where the user input data which gets added to a hidden sheet (sheet1)
What I require your help in is:1PNG.PNG

• When the user input and click submit his record should be dispalyed
• Mail his entred record using outlookDisplay
• Fix the userform to a sheet,the user form need not float
• In the designed form I have days name,I want to dispaly dates below each days name from the hidden sheet

Please find the code below:

Please Login or Register  to view this content.

Can anyone suggest anything?