Latest Lists

Waiting List excel template?

A poker room I go to has a spread sheet they use for a waiting list. They put people who want to play at the bottom of the list, then when that person makes it to the top of the list and they want to remove them, they just hit a button that's been written into the spread sheet. Does anyone know where I can find a template like that one?

Public Comments

1. Insert a command button on your worksheet. (Excel 2003) Click View -> Toolbars -> Control toolbox. Click once on the Command button icon. Click once in the cell where you want the button to appear. Resize the button. On the Control toolbox, click the Design icon (setsquare). Right-click the command button -> view code. BETWEEN the two lines of code insert this:- ' ' Select row 1 and delete. Application.Goto Reference:="R1" Selection.Delete Shift:=xlUp Close the Visual basic screen. While in design mode you can also change the label of the command button. right-click, select properties. Go to the Caption row, and type Delete. Click once on the Design icon. Now test your button to see if it works properly.