Compile Error: 'Expected variable or procedure, not module'

Question

How do I explain the 'expected variable or procedure, not module' error in this instance?

Code:

Routine -

Sub WTS_9_Click()
    Call Module1
End Sub

Module -

Sub Rec_9_Click()

The error came about because I learnt a better way to structure code by calling in sub-routines through modules. I have activated the Solver, carefully renamed Modules - set variables, functions and other objects are not interfering - and, yet, it remains stuck. Ideas to help explain the jam would be appreciated.

braX · Accepted Answer · 2020-07-08 12:00:49Z

1

You dont Call a module, you Call the routine, and the word Call is optional.

You probably want this:

Sub WTS_9_Click()
    Rec_9_Click
End Sub

answered Jul 8, 2020 at 12:00

braX

11.9k5 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Geoffrey Turner Over a year ago

Ah, yes, OK, calling passes through the module. Gotchya.

TWP · Accepted Answer · 2020-07-08 12:06:49Z

1

Within you module you need to declare (public) routines, i.e.

Module (named Test)

Public Sub TestMessage()
    MsgBox "Test"
End Sub

Then in your code (i.e. events) you can call this routine within the module:

Sub Button_Click()
    call TestMessage
    call Test.TestMessage ' you can skip the module name if routine name is unique
End Sub

answered Jul 8, 2020 at 12:06

TWP

2701 gold badge6 silver badges13 bronze badges

Collectives™ on Stack Overflow

Compile Error: 'Expected variable or procedure, not module'

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related