Excel 5.0 Dialog Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2052994%22%20slang%3D%22en-US%22%3EExcel%205.0%20Dialog%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2052994%22%20slang%3D%22en-US%22%3E%3CP%3EThese%20were%20replaced%20long%20ago%20with%20User%20Forms%2C%20but%20were%20left%20with%20backward%20VBA%20compatibility.%20I%20have%20one%20left%20that%20I%20hadn't%20thought%20about%20since%20then%20until%20it%20just%20stopped%20working%20yesterday.%20Running%20a%20macro%20with%20the%20VBA%20line%20%22DialogSheets(%22Input%22).Show%22%20no%20longer%20pops%20up%20the%20dialog%20box%20named%20%22Input%22%2C%20but%20gives%20me%20an%20undefined%20VBA%20400%20error.%20If%20I%20run%20it%20from%20within%20VBA%2C%20I%20get%20%22Run-time%20error%20'1004'%3A%20Show%20method%20of%20DialogSheet%20class%20failed.%22%20Does%20this%20likely%20mean%20Microsoft%20has%20ended%20the%20backward%20compatibility%3F%20If%20so%2C%20is%20there%20a%20way%20that%20I%20can%20convert%20the%20dialog%20sheet%20to%20a%20user%20form%20without%20having%20to%20manually%20rebuild%20the%20whole%20thing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2052994%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

These were replaced long ago with User Forms, but were left with backward VBA compatibility. I have one left that I hadn't thought about since then until it just stopped working yesterday. Running a macro with the VBA line "DialogSheets("Input").Show" no longer pops up the dialog box named "Input", but gives me an undefined VBA 400 error. If I run it from within VBA, I get "Run-time error '1004': Show method of DialogSheet class failed." Does this likely mean Microsoft has ended the backward compatibility? If so, is there a way that I can convert the dialog sheet to a user form without having to manually rebuild the whole thing?

1 Reply

@Don_Jennings I am also having this issue... just started happening 1/26/2021.

The macros worked the day before, but failed the next day all of a sudden... Not sure what happened. I have 365. Hopefully it's just something microsoft needs to fix and quick...