## where's the formula defined ?

## where's the formula defined ?

(OP)

Hi,

I have a s/sheet from a vendor to refers to a formula "Fcc_bruhn_C7_30(...)".

I recognise what the formula is trying to do, but I can't find the expression in the s/sht.

Thoughts ?

I have a s/sheet from a vendor to refers to a formula "Fcc_bruhn_C7_30(...)".

I recognise what the formula is trying to do, but I can't find the expression in the s/sht.

Thoughts ?

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

sorry Excel 11 (I think !?)

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: where's the formula defined ?

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

Cheers

Greg Locock

New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?

## RE: where's the formula defined ?

I think this means the formulas/macros are on the vendor's computer and didn't ship with the s/sht.

If I force a re-calc I get "WTF?".

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

## RE: where's the formula defined ?

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: where's the formula defined ?

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

Did you Enable Macros?

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: where's the formula defined ?

Oh yeah...not on by default. File > Options > Customize Ribbon

## RE: where's the formula defined ?

Didn't know that shortcut. Thanks!

## RE: where's the formula defined ?

another day in paradise, or is paradise one day closer ?

## RE: where's the formula defined ?

Function Fcc_bruhn_C7_30(Fcy As Double, Ec As Double, bt As Double, edge As Integer) As Double

Dim k_edge As Double

Dim Fcc As Double

If edge = 1 Then

k_edge = 0.566

ElseIf edge = 0 Then

k_edge = 1.425

End If

Fcc = (k_edge * (Fcy ^ 0.6) * (Ec ^ 0.4)) / (bt ^ 0.8)

If Fcc > Fcy Then Fcc = Fcy

Fcc_bruhn_C7_30 = Fcc

Cheers

Greg Locock

New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?

## RE: where's the formula defined ?

buckling

crippling

Interpolation

section_analysis

Each has one or more procedures (subs & functions).

Fcc_bruhn_C7_30 function is in crippling.

flng_sect_props is in section_analysis.

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: where's the formula defined ?

Alt-F8 will open a dialog with a list of macros (i.e. routines defined as Sub()), and you can choose Run, or Edit or Step Into to view the code.

Alt-F8 will not display functions, but if you start to type =function_name the VBA functions will be included in the list of available functions, as well as the built in ones. You can then select the one you want, and click on the function wizard (fx, next to the name box), to see the required input.

To view a function code you have to go to the VBA Editor (Alt-F11, or Developer tab, if you must), then search for it. If using the search function (Alt-F), and you want to search all modules, make sure the search Project option is selected.

To step through a function:

- Go to the function code in the VBA Editor, and set a break point near the start (or from wherever you want to step)

- Go back to the worksheet and select a cell calling the function, then press F2-Enter.

- You can then step through the code with F8, etc, as for a subroutine.

Doug Jenkins

Interactive Design Services

http://newtonexcelbach.wordpress.com/

## RE: where's the formula defined ?

UDFs do not autocomplete like the built in excel functions, so it's harder to know what you should be entering.

https://engineervsheep.com

## RE: where's the formula defined ?

Thanks, I'd somehow missed that.

I think I still prefer the function wizard in general, but the shortcut is good if you just want a quick look at the arguments.

Doug Jenkins

Interactive Design Services

http://newtonexcelbach.wordpress.com/