2 Macros conflicting with each other

**brianf** · 08-13-2010, 06:09 PM

I have a spreadsheet with several macros and two of them seem to conflict with each other. I'm not a VBA expert so there's probably a simple reason for it so I'll post the two macros here.
Popup Calendar userform

Please Login or Register  to view this content.

Macro that calls this userform

Please Login or Register  to view this content.

This worked fine until I added another macro for updating a formula calculation when new data is added.

Please Login or Register  to view this content.

Can anyone tell me what I need to change to make this work?

**Andy Pope** · 08-14-2010, 06:27 AM

You do not say what the actual problem is, nor do you show the CopyBalance
routine.

I guess the problem is the worksheet change event firing when you update the activecell. If you do not want the event to run you will need to disable events whilst updating the sheet.

Please Login or Register  to view this content.

**brianf** · 08-15-2010, 06:04 PM

Sorry I missed saying what error I'm getting...
The message box says "Run-time error '400': Form already displayed; can't show modally"

The CopyBalance macros is

Please Login or Register  to view this content.

When I added the code you suggested Andy, the calendar pops up in columns where I enter the data, not just column B which is my Date column.

I would also like the cursor to return to the position where the last data was entered when the CopyBalance macro ran. Any suggestions for this?

**Andy Pope** · 08-16-2010, 04:14 AM

The error suggests you have code somewhere that is trying to load the userform whilst it is already displayed. I can not see that in the code you have posted.

Can you post workbook example.