The file is located http://mtrosemedia.tk/wp-content/upl...ent-Sheet.xlsm
I am trying to create a form that does a couple of things. I have tried to learn through many forums, but I am losing my mind. I am sleeping <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>, and I still don't know a small percentage of it.
I will explain in detail what it should do.
The First Worksheet (ws1) is the user entry field. The name goes into cell B1 and when the "Apply" button is hit, it begins to build the form.
The only editable fields for entry are B1 and the checkboxes.
(The Cell B1 is used because I did not know how to use a Text Form Control instead, and make that work with the <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VB</acronym> code I have.)
Once the form is built, people can check off the boxes as the tasks are done. When the last task is complete, (Project Complete), the row becomes either dithered, or moved to another section of the worksheet, or just removed.
On Worksheet 2 (ws2), all the data should be replicated, but instead of check boxes, the cells are filled with dates. That's all. Nothing is editable on this page, just printable.
Worksheet 3 (ws3), The projects that have a (Project Complete) status will be placed here with the date.
After 2 years, those same projects will move to Worksheet 4 (ws4)
I am just trying to keep track of Project Progress while keeping track of Project location as well. I can do this in PHP, but in excel it is hard.
ANY ADVISE IS APPRECIATED. I am a complete noob when it comes to <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VBA</acronym>.
The file is located http://mtrosemedia.tk/wp-content/upl...ent-Sheet.xlsm
I am trying to create a form that does a couple of things. I have tried to learn through many forums, but I am losing my mind. I am sleeping <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>, and I still don't know a small percentage of it.
I will explain in detail what it should do.
The First Worksheet (ws1) is the user entry field. The name goes into cell B1 and when the "Apply" button is hit, it begins to build the form.
The only editable fields for entry are B1 and the checkboxes.
(The Cell B1 is used because I did not know how to use a Text Form Control instead, and make that work with the <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VB</acronym> code I have.)
Once the form is built, people can check off the boxes as the tasks are done. When the last task is complete, (Project Complete), the row becomes either dithered, or moved to another section of the worksheet, or just removed.
On Worksheet 2 (ws2), all the data should be replicated, but instead of check boxes, the cells are filled with dates. That's all. Nothing is editable on this page, just printable.
Worksheet 3 (ws3), The projects that have a (Project Complete) status will be placed here with the date.
After 2 years, those same projects will move to Worksheet 4 (ws4)
I am just trying to keep track of Project Progress while keeping track of Project location as well. I can do this in PHP, but in excel it is hard.
ANY ADVISE IS APPRECIATED. I am a complete noob when it comes to <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VBA</acronym>.
The file is located http://mtrosemedia.tk/wp-content/upl...ent-Sheet.xlsm
