Creating a VBA input form, please help/guide me.

[sailorzane]

I have a workbook that i am trying to create a data input form but have little knowledge of VBA. Knowing I shouldn't approach this alone I am seeking assistance. I need to know where and how to start this. The form needs to be able to add new employees, simply the name as a whole unit, also needs an input with dropdown and date so one can select an employee and then select or type a date and select if they took a sick day, personal day etc. The workbook has a data sheet that will contain the info but I want a form to input this info. I want the same form to contain the option to input any absent days for the selected employee.

[Logit]

.
This will get you started ...

Please Login or Register  to view this content.

The example code provide for entering a FIRST name and a LAST name to the worksheet. It can be edited to enter both at the same time, to a single cell.

The code also provides for deleting an entire row on the sheet should that be required. The user selects a cell in the row to be deleted, then clicks the button.

And there is a basic command for unloading the userform.


Suggest you study the code and the attached example for a better understanding. You can build the remainder of your project from here.

NOTE: the coded will 'write' data to the ACTIVESHEET.