Macro Runs fine in debug but not from ComboBox

I am using a ComboBox from the controls toolbox (AxtiveX). I can attach a sample workbook. I will need to copy my wookbook and delete all of the personal information. This will take a little time.

Thanks...J

SHG...I'm not sure I understand your question, however, when I run the macro, the user is asked to enter the row number they wish to delete. They can enter any number greater than 7 (column headers, etc. are in the first seven rows). Also, there are certain other rows that are reserved (I have entered X's in column A of these rows and the macro looks to see in column A is empty; if it's not empty, the macro tells them they cannot delete this row.

Now, this works fine in debug; however, from the ComboBox, the Input box reappears and asks for a row number (it should not reappear, the macro should complete).

After the Input box reappears, if I enter a 0, the macro completes; if I select cancel, the macro completes; if I enter a legitimate row number, I get the message "Delete Method of Range Class Failed". However, I should not even be looping back to the Input box. Therein lies the problem. Why am I getting a second view of the input box when I run the macro from ComboBox when I don't get a second view in debug?

Does this answer your question?

J

I have attached a test file as requested. Please ignore the #REF references. I've deleted several worksheets to reduce the size of the file and they have no relevance to the issue.

Thanks....J

royUK...I've replaced my Private Sub ComboBox1_Change() coding with that you suggested (I did this in a copy of the file I submitted earlier). I still get the same results....a second Input Box.

Take a look at the file I provided and see if you can duplicate my problem. Run the macro (macro 16) in debug (F8) and it will complete without a second pass at the Input Box. Running from ComboBox results in a second pass at the Input Box.

Let me know if you cannot duplicate the issue.

Thanks...J

royUK...I replaced my macro coding with the code you suggested. I ran the insert macro from the ComboBox to give me a few extra rows to play with.

I then ran macro16 (the delete macro) from the ComboBox. It appeared to run the first time. I didn't get a second input box prompt. I ran it again (to delete one of the new extra rows I inserted).

This time, I did get another input box prompt. Is something not clearing to cause the input box prompt to come up again?

Thanks...J

royUK...yes, I had previously tried to set y=0; had no effect. The interesting thing is that the insert macro works fine. It does not give me the second Input Box.

I had previously cloned the insert macro for the delete macro (with obvious changes and deletions). However, the problem we are discussing arose so I rewrote the macro but still have the issue. Have you been able to duplicate the problem?

Thanks...J

royUK...this is my current code. Still have same problem. Looping back to InputBox.

Please Login or Register  to view this content.

That did the trick. Thank you very much. I spent 3 frustrating days trying to get the macro to behave.

Your help is greatly appreciated.

J