code for userform to delete combo box value from dynamic range & move column up

but I have no idea where to start on deleting the employee (cbo5) from my dynamic range, "EmpList," other than I need to select the range and probably use delete Shift:= xlup...

Is there a reason that you cannot use this method?
Untested:

Please Login or Register  to view this content.

How are you populating the combobox from the dynamic range?

Is the employee you want to delete from the list on ws2 selected in the combobox?

Norie, I'm assuming OP has already successfully tested value in the ComboBox, as that value is being used programmatically to look to a range and change the value to "Former Employee".
OP is struggling to take that value cbo5 find it in a range, delete just that name, and shift the rest of the range up.

If cbo5 has been populated from the dynamic range it should be straightforward to find the employee if they are selected in the combobox as the ListIndex of the combobox will directly correspond to the row within the range.

The reason I asked how the OP has used the range to populate the range is because if they have used RowSource there could be problems.

Got ya! You were pretty well on your way with the post, I just figured maybe there was a reason you couldn't use that particular method.
No need to set dimension!

Best of luck to you!

The code to populate the combobox should go in a userform's initialize event, definitely not in the change event of the combobox.

You actually posted code for the Initialize event, was there a problem with it?

Also, what formula are you using for the dynamic range?

Are you using the dynamic range elsewhere, eg on a worksheet?

If you aren't then you could probably get the list of employees in code.

By the way, why are you using a separate form for delete employees?

Couldn't you use your main form?

Put this in the code for the userform DeleteEmp,

Please Login or Register  to view this content.

and delete this.

Please Login or Register  to view this content.

Now the combobox will be populate as soon as you open the userform.

As for setting focus on cbo5 when the userform open try this.

1 Right click the form.

2 Select Tab Order.

3 Move the controls Up/Down as appropriate, eg if you want cbo5 to have focus when the userform opens move it right to the top.

While I'm here, there's a problem on the EmpAdd form.

You've named a button on that form EmpAdd.

That's not a good, try changing the button name to something like btnEmpAdd


Back to deleting the employee.

Change the code for the DelEmp button to this.

Please Login or Register  to view this content.

Yes I saw that.

It should be quite simple to fix, all you need is code to copy the formula down from A2 (or A3?).

Or code to fill in the formula in the required no of rows.

I think the latter might be easier.