Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA macro Trignometry function
Hi,
I am very much new to VBA programming, started just two days ago. i need to write a code which uses cos and sin functions. i tried using Sin and Cos functions. but i have got a strange problem, that when ever i type Cos in VBA editor , as soon as i hit enter Cos is changing to COS. I actually tried to create a function named COS and call Cos from that Initially, But i deleted, since then whenever i type Cos it is changing to COS. Please help how to solve this problem. Thanks in Advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macro Trignometry function
"Spint" wrote:
when ever i type Cos in VBA editor , as soon as i hit enter Cos is changing to COS. I actually tried to create a function named COS [...]. But i deleted, since then whenever i type Cos it is changing to COS. Right, that was my experience when I tested this. Simply creating any variable named COS, then deleting it causes VBA to remember that Cos was once written COS. And AFAIK, nothing will change that except.... Replace COS with myCos (any capitalization will do) throughout the module, export it, and remove it. Then save and close the workbook. Reopen the workbook, import the module, and replace myCos with Cos. Save the workbook. Note: I tried this with only one module. You might need to experiment further if you have multiple modules. Worst-case scenario: you might need to export and remove every module. |
#3
|
|||
|
|||
Quote:
I actually removed all the modules and copied the code. i was having very less modules, so less pain. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a Function or Macro for This? | Excel Discussion (Misc queries) | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
macro or function? | Excel Discussion (Misc queries) | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Function or macro help | Excel Programming |