program working in the code application, but not the excel sheet

Hi all,

When I run my program by pressing play in the code application, everything works just the way I want it to, but when I try to run it through the excel sheet by pressing a button, it is not doing what I want it to do.

I am using this code: It is in one of my userforms.

Please Login or Register  to view this content.

I have attached the workbook. The code can be found under the userform 'MelvMaint' at the bottom.
Through the worksheet: 'Home Page (Sheet)' -> 'Maintenance (button)' -> 'Update (tab)' - > 'delete (button)' -> (changes are made on 'Read Only')
--I want the combo boxes to automatically update once an item is DELETED from the list

Please Help

Hi TMShucks,

I am very new to vba.
'Full stop?' Is that the '.' you put before each 'Range'
thanks

Im not sure if I should post a new thread for this, but now its doing something different than before. I'm adding 'Emily' to the list more than once, so I have about 5 Emily's now on the list, but when I press delete, It deletes all 5 at once. Is there a way to make it so that it deletes only the one that I have selected from the combobox?

Thanks Joseph! Works Great