Excel Add job dialog box and autosorting.

I have a three column list (B:D) in a multiple sheet
workbook that deals with B:Active yes/no C:Job # and
D:Job Name. I need a dialog box to pop up when I push
an ADD JOB button, to insert the next job (including
job # and active status)into the list.

I can figure out how to design the dialog box to enter
this info into one row (5B:5D for example), but I don't
know how to A)make the list auto sorting, by D, then by
C, or B)make the dialog box enter info into the next
unfilled row.

Column A has a countif formula all the way down the sheet,
and column E has a totalling formula all the way down,
so the next row won't be completely empty, just B:D.
Can someone please help me with this. I would appreciate
it if you guys could save me once again.

Thanks
Robert

Robert
You can use the macro recorder to get the code for sorting.
For the next available cell in column B :-
Range("B65536").End(xlup).Offset(1,0)
Celia

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

Add job dialog box and autosorting.

Re: Add job dialog box and autosorting.