The first suggestion as always is to post the code in the worksheet_changed
function pointing to the line that is giving the exception and to say which
cell is being changed so that somebody can debug the code.

Peter Richardson

"jnf40" wrote:

I have a userform that the user selects a name from a combobox then it will
insert the name on the worksheet in a certain cell when they click on
commandbutton1. When this button is clicked it runs through and goes to
Private Sub Worksheet_Change(ByVal Target As Range), which is on sheet1 and
it comes back with Exception Occurred and Invalid Property Value messages.
Any suggestions?
Thanks