Microsoft Visual basic Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2232143%22%20slang%3D%22fr-FR%22%3EMicrosoft%20Visual%20basic%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2232143%22%20slang%3D%22fr-FR%22%3E%3CUL%3E%3CLI%3E%3CP%3Eissue%20related%20to%20Microsoft%20Visual%20basic%20execution%20error%20'-2147417848%20(80010108)%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EDialogSheets%20(%22Dialog1%22).Show%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECan%20you%20help%20me%20to%20update%20the%20VBA%20code%20so%20that%20the%20macro%20is%20functional%20again%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E(Can%20you%20help%20me%20update%20the%20VBA%20code%20so%20that%20the%20macro%20is%20functional%20again)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2232143%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
  • issue related to Microsoft Visual basic execution error '-2147417848 (80010108)

  • DialogSheets ("Dialog1").Show

 

Can you help me to update the VBA code so that the macro is functional again

(Pouvez vous m'aider pour mettre à jour le code VBA pour que la macro soit de nouveau fonctionnelle)

1 Reply

@Phili94230_PhH 

 

Which Sub-routine and on which module you are having issue with?
In some of your procedures you have used a line which says Sheets("Dialog2").Select but there is NO Sheet called Dialog2 in the workbook.