Forum Discussion

LilYawney's avatar
LilYawney
Brass Contributor
Mar 23, 2023
Solved

VBA Debugging Help

I have MANY problems with my VBA codes after translating them from French to English. Below I've organized them by Modules (See reply for full VBA codes for each module). All these issues are related...
  • HansVogelaar's avatar
    HansVogelaar
    Mar 23, 2023

    LilYawney 

    Call print_sheet_risk_assessment(Sheet_3) fails because the procedure is named print_sheet_RISK_ANALYSIS, not print_sheet_risk_assessment

     

    Call prints_sheet_hazard_control(Sheet3) fails because the procedure is named print_sheet_hazard_control, not prints_sheet_hazard_control

     

    In print_sheet_RISK_ANALYSIS, you declare a variable area_print but then use print_area

     

    In print_sheet_hazard_control, the line

     

    greatest_large = WorksheetFunction.Max(a, B)

     

    fails because  a and B have not been assigned a value.

    The variable greater_large has not been assigned a value. Should it be greatest_large? Or greatest_big?

    Same confusion between print_area and area_print

     

    Same in print_sheet_memory_help

     

    find_last_row_written, management_particular_case and management_case_ASP_Construction are not in the code as posted.

     

    In copy_PPE_in_temp, should instructions be statements or vice versa?

     

    management_val_mult_training etc. do not exist.

     

    In management_val_mult_instructions,

    long_car = Len(statements)

    fails because statements has not been assigned a value, nor instructions (are they the same?)

    Should long_car and long_char be the same?

     

    And lots more, but by the time I got there I had had enough.

Resources