Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
?
Really not sure what the subject is but I will describe my thoughts.
I have got a list of names, associated with those names are employee badge numbers, what I would like to do is when a employee quits, terminated, etc. I would like to scroll through a list of names find their badge number and delete it through code. Reason being is there have been times when a number was accidentally delete, with code hopefully I can get their acknowledgment of this before it ever happens. Also it would be handy if the need come to relocate origin of the employee (which the number changes when that happens) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
?
David,
You could create a userform with a Combobox. Have the RowSource of the combobox be set to the column-range of your employee names. You can make this a self-expanding named range so that you don't have to constantly set the rowsource. The combobox makes it easier because it automatically scrolls to the name in the list as you type. Than you can have code behind the form to clearcontents of the cell or delete the row (depending on which you after. The row number should be = to Combobox1.ListIndex + 1 Post back if you need more help. steve "David W" wrote in message ... Really not sure what the subject is but I will describe my thoughts. I have got a list of names, associated with those names are employee badge numbers, what I would like to do is when a employee quits, terminated, etc. I would like to scroll through a list of names find their badge number and delete it through code. Reason being is there have been times when a number was accidentally delete, with code hopefully I can get their acknowledgment of this before it ever happens. Also it would be handy if the need come to relocate origin of the employee (which the number changes when that happens) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
?
Never have done a user form and combo boxes before. Can you shed some light
on this. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
?
Have you looked at the built in Form under the Data menu.
I assume your data starts in row 1 with header information. Click the header and do Data=Form. this will allow you to navigate through your data table and make changes or delete data. -- Regards, Tom Ogilvy "David W" wrote in message ... Really not sure what the subject is but I will describe my thoughts. I have got a list of names, associated with those names are employee badge numbers, what I would like to do is when a employee quits, terminated, etc. I would like to scroll through a list of names find their badge number and delete it through code. Reason being is there have been times when a number was accidentally delete, with code hopefully I can get their acknowledgment of this before it ever happens. Also it would be handy if the need come to relocate origin of the employee (which the number changes when that happens) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|