| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show formulas and evaluaion with excel prgram created with VB
Dear Experts,
Normally, I use the evaluate formula to see how the calcs are performed. However, there is a program that was created using Visual Basic. I am not able to see the calculations behind it. How do I access this? I have the password to get into this program via Visual basic editor but I all I see is VB language etc. Is there a way I can see the figures being calculated? Kind Regards Ed |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show formulas and evaluaion with excel prgram created with VB
Eddie Morris wrote:
Dear Experts, Normally, I use the evaluate formula to see how the calcs are performed. However, there is a program that was created using Visual Basic. I am not able to see the calculations behind it. How do I access this? I have the password to get into this program via Visual basic editor but I all I see is VB language etc. Is there a way I can see the figures being calculated? Kind Regards Ed Ed, This is probably not the answer you were hoping for... It seems the calculations are dispersed in the VBA code. It may or may not be immediately obvious how the calculations work, but you will need to study the VBA code to sort it out. Best of luck. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel X for Mac - show formulas | Excel Worksheet Functions | |||
| Colours in a Created Planner do not show on a users Machine on ope | Excel Worksheet Functions | |||
| Is there a way to not show the 'date created' on Excel files? | Excel Discussion (Misc queries) | |||
| A chart needs to be created to show names and $ amounts 400-6K | Charts and Charting in Excel | |||
| How do I get custom views created in Excel 2K to show in Excel 200 | Excel Worksheet Functions | |||
Hybrid Mode
