old makro (excel 95) should work with vba-modules

[Michael Gerstel]

hi ng,

i had some old makros (excel 95) which are should also work on excel xp.
how i could run functions and procdures written in vba from a old excel
makro.

when i work like that

= .... (old makro command)
= ....
= new_function_written_in_vba()
= ... (old makro command)

it didn't work. what's wrong?

thanks
michael

 

[Jim Rech]

It looks like you're trying to call a VBA sub from an Excel 4 macro sheet.
If so, you seem to be doing it right. This worked for me:

In an Excel 4 macro sheet:

RunThis
=CallVBfromXL4()
=RETURN()

And in a VB module in the SAME workbook:

Sub CallVBfromXL4()
MsgBox "call worked!"
End Sub


--
Jim Rech
Excel MVP
| hi ng,
|
| i had some old makros (excel 95) which are should also work on excel xp.
| how i could run functions and procdures written in vba from a old excel
| makro.
|
| when i work like that
|
| = .... (old makro command)
| = ....
| = new_function_written_in_vba()
| = ... (old makro command)
|
| it didn't work. what's wrong?
|
| thanks
| michael
|
|