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

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