| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Visual Basic Function works fine in Excell 2003 but not in Excel 2
I have an Excel worksheet with Buttons and Macros and Visual Basic code which
was created in Excel 2003 and works fine (everything functions). However, when I moved the file to Excel 2007, only the Visual Basic Function no longer works (the macros and buttons operate fine). When I use "Evaluate Formula" for the Visual Basic Function, it provides the correct answer. However, when I press Calculate (F9) or when I press Enter with the cursor at the end of the function's formula on the "Fx" line, I get "#VALUE!" and don't understand why. Any ideas? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table is not valid in Excel 2000 but works fine in EXCEL 200 | Excel Discussion (Misc queries) | |||
| Macro hangs up often but sometimes works fine | Excel Worksheet Functions | |||
| Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
| changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
| Excel and Visual Basic | Excel Discussion (Misc queries) | |||
Threaded Mode
