Exception Occurred

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enumerate buttons on user form 2
paste special in this vba code? 1
If cancel list box don't enter FALSE in list 2
Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
.pdf file not working in UserForm 4
Working with 2 range but wont work with 3 7
Set Userform label text if form is not loaded??? 3

Back
Top