As a novice ind VBA i am sorry if this issue already has been answered.
I have an excel sheet with data containing information about personel and products
I would like to create en Userform to update a sheet called "Database" with the following information;
When you click "Send data/Update" the "database" is updated with the information from the Userform.
In the sheet "database" there is some calculations which means the sheet "Database" containing these columns:
Date
Employee number
Employee Name
Product number
Product Name
Number of products manufactured
Manufacturing Code
Price
Total price
All these information should appear in the Listbox after update of the "Employee number" Combobox.
After clicking "Send data/Update" the new data should appear in the Listbox.
The Listbox should be sorted with the newest date on top.
Could anybody in here help with this ?
Thanks
I have an excel sheet with data containing information about personel and products
I would like to create en Userform to update a sheet called "Database" with the following information;
When you click "Send data/Update" the "database" is updated with the information from the Userform.
In the sheet "database" there is some calculations which means the sheet "Database" containing these columns:
Date
Employee number
Employee Name
Product number
Product Name
Number of products manufactured
Manufacturing Code
Price
Total price
All these information should appear in the Listbox after update of the "Employee number" Combobox.
After clicking "Send data/Update" the new data should appear in the Listbox.
The Listbox should be sorted with the newest date on top.
Could anybody in here help with this ?
Thanks