Start Hide screen updating excel vba

Hide screen updating excel vba

We can add new staff and delete staff from our Excel Userform.

When you click on the Update Drop Downs button, the VBA code uses the “Data” worksheet as a table and then finds unique values for Products, Region and Customer Types and then populates them as List Items for the Combo Box controls.

It has been developed in Microsoft Excel 2013 but will also run in Excel 2010 and previous.

In the templates that you downloaded you will notice one of the modules is called Assorted. The user form will now open when you click this shape.

The code that you see below should be copied and pasted into that module On the Interface sheet you will notice a button (shape) that says “Add and Edit Staff”. When data is added to our database we want to sort that data.

In the procedure below we will be sorting the data by column E. Note: you may have commented out this macro in the Private Sub cmd Add_Click procedure.

Well I would have adopted this method and wrote a simple query as below.

This would allow me to use both the sheets as one table and fetch all of my data into a new sheet.

So you may wish to add this now and run it from a button on the Interface sheet for the time being.