Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
old makro (excel 95) should work with vba-modules
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
old makro (excel 95) should work with vba-modules
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 "Michael Gerstel" wrote in message ... | 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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel makro hatası (Bul değiştir yanlış çalışıyor ) | Excel Discussion (Misc queries) | |||
Start Excel inside MSaccess with a makro | Setting up and Configuration of Excel | |||
Makro in excel | Excel Worksheet Functions | |||
Excel Makro Language (Excel 4.0) Tutorial? | Excel Discussion (Misc queries) | |||
Excel-Makro for automatically generated protocol out of todo-list | Excel Programming |