Im creating a poor man's small business database. I have excel workbook that has the following sheets- Index, Deals, Companies, Clients, Orders, Invoices, Products etc
- Sheet 1 is Index sheet (user interface) to click on buttons to open specific forms feeding into other sheets in workbook (Add New Deal, Add New COmpany, Add new Product) etc
My question is, how do i code each button on one worksheet, to call to open a userform for data entry into a separate worksheet?
example: Index has white background with 9 separate buttons. I want to click button " Add New Company" and it opens the pre made Userform that adds data to the "Companies" sheet
I have tried multiple times to code as instructed but keep getting "variable not defined" or "block If without End If" or module not found