Adding new record, sorting and formatting

[stait]

Hi there,

I have a resource data base where I need to added resources for tracking purposes. I have created a userform to add a new record. What I would like to also have this marco do is sort the table by column G after the record has been added and format each cell with a light grey border once the record has been added.

Thank you for your help.

The code I have so far is the following:

Please Login or Register  to view this content.

[Leith Ross]

Hello stait,

Does column "G" have a header in row 1?

[stait]

Hello stait,

Does column "G" have a header in row 1?

Hi there,

Yes, it is "Full Name" and it is in row 7.

Thank you again for your help.

Stephen

[Leith Ross]

Hello Stephen,

Are the borders for each cell in the table or just for the cells in column "G"?

[Leith Ross]

Hello Stephen,

This macro will sort the table using column "G". It adds a thin line gray border around each cell in the last row. You may have trouble seeing the borders as this setting is the same as Excel's default gridline color. The line is thicker than the default setting.

Please Login or Register  to view this content.

[stait]

No, there are boarders for the chart....Column A-AP....and for all rows with data. The boarders are: Line Weight - Standard - Grey - 25%

[stait]

Thank you so much for this. I seem to be having trouble...where in my code would I add this. I have tried a few things and it does not seem to work.

Thank you again

[Leith Ross]

Hello stait,

If you post your workbook, I can add it in for you. If you want to do it yourself, here are the directions.

Adding the Macro

1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
   
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

[stait]

Hello stait,

If you post your workbook, I can add it in for you. If you want to do it yourself, here are the directions.

Adding the Macro

1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
   
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Hi Leith,

Thank you again for all your help.

below is the code I am using for adding a record. Right now the record is being added to the first blank row after data. What I want to have is once the data is added, the cells are formated to have a light grey boarder in each cell. I would then like to have the data sorted by column "G" - "Full Name". The columns with data are A - AP.

Thank you again.

Stephen

Please Login or Register  to view this content.

[stait]

I was wondering if anyone knows a macro which will turn off all filters when you close your Excel Sheet. I have a sheet which is used by many people and I am finding people are using the filters to sort data and when the next person used the sheet, they are always trying to figure out what filter is on.

Thank you

Stephen