×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

where's the formula defined ?
3

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 ?

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

RE: where's the formula defined ?

(OP)
where are macros defined ?

sorry Excel 11 (I think !?)

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

RE: where's the formula defined ?

(OP)
found "macros" (on the "view" ribbon ... Y oh Y) ... but my formula isn't there ??

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

RE: where's the formula defined ?

(OP)
actually Excel 2016

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

RE: where's the formula defined ?

Upload the workbook?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: where's the formula defined ?

(OP)
thx greg, tried that, got the usual Excel "WTF?" ... (screen shot attached).

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 ?

(OP)
but humm ... if I change the precedents, the result changes ... so the formula is live ? but doesn't survive "cut and paste" ??

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

RE: where's the formula defined ?

rb: Developer tab. Visual basic.

RE: where's the formula defined ?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: where's the formula defined ?

(OP)
thx guys ... it'd help if I had the "developer" tab on my ribbon !? must ask "Mordac" ...

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

RE: where's the formula defined ?

Alt+F11 toggles between sheet and VB Editor.

Did you Enable Macros?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: where's the formula defined ?

Quote (rb1957)

it'd help if I had the "developer" tab on my ribbon

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

RE: where's the formula defined ?

Quote (SkipVought)

Alt+F11 toggles between sheet and VB Editor.

Didn't know that shortcut. Thanks!

RE: where's the formula defined ?

(OP)
damnit ! I was looking for that ribbon thingy ...

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

RE: where's the formula defined ?

I should have looked at your screenshot, yes developer->view code

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 ?

As you can see there are 4 modules in the VB Editor…
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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: where's the formula defined ?

Some more hints for working with VBA:

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 ?

To add to what IDS noted, Ctrl+shift+A is also your friend when working with udfs, it will fill out the variables so you can replace with your own references.

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 ?

Quote (Agent 666)

Ctrl+shift+A is also your friend when working with udfs

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/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close