Getting VBA to recognize if Excel Data Form is open

**fats3287** · 07-10-2009, 06:37 PM

Hi everyone,

I am currently working on a workbook with VBA code and have run into a wall. Is there a way in VBA code to recognize if the standard Data Form is open?

Shawn

**fats3287** · 07-10-2009, 06:38 PM

Forgot to mention I am using Excel 2003

**fats3287** · 07-10-2009, 07:25 PM

Got it to work a little differently but the fix is in

**shg** · 07-10-2009, 08:36 PM

Good job. Care to share?

**fats3287** · 07-24-2009, 11:16 PM

It's not so much that I got it to recognize if it was open, but that I relized having the form open pauses a macro so I was able to just have what I wanted to happen in the macro after I listed the command to open the data form. that way when the form is closed the macro just starts up where it left off. Works great.