Hi
I am new to VBA and need some assistance with an error in the code
I have set up a workbook with 6 worksheets
1st Worksheet i have Menu which is where i will store my buttons to open each user form as listed below
2nd Worksheet is named summary as this is where i will store totals from the other worksheets
3rd Worksheet is named Suppliers
4th Worksheet is named Hours
5th Worksheet is named Contractors
and so goes on the list
I am able to click on the menu tab and the click on the materials button which pops up the user form and can enter data into the form but it wont insert data
In the code it comes up with a debug error 1004 and highlights the following code
I hope some one can point me in the right direction as once i get this form right i will repeat on the other worksheets![]()
Please Login or Register to view this content.
I have included my spreadsheet if you need to see what i have done
Bookmarks