Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
where's the formula defined ? 3
- Thread starter rb1957
- Start date
- Thread starter
- #2
- Thread starter
- #3
- Thread starter
- #4
SkipVought
Aerospace
Upload the workbook?
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...
for a NUance!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
Skip,
Just traded in my OLD subtlety...for a NUance!
- Thread starter
- #6
GregLocock
Automotive
You need to look at the Name Manager which is under Formulas, about half way along the ribbon.
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376
- Thread starter
- #8
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 ?
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 ?
- Thread starter
- #9
-
1
- #10
-
1
- #11
SkipVought
Aerospace
Skip,
Just traded in my OLD subtlety...for a NUance!
- Thread starter
- #12
SkipVought
Aerospace
Alt+F11 toggles between sheet and VB Editor.
Did you Enable Macros?
Skip,
Just traded in my OLD subtlety...
for a NUance!
Did you Enable Macros?
Skip,
Just traded in my OLD subtlety...for a NUance!
- Thread starter
- #16
GregLocock
Automotive
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
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
SkipVought
Aerospace
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,
Just traded in my OLD subtlety...
for a NUance!
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!
-
1
- #19
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
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
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.
UDFs do not autocomplete like the built in excel functions, so it's harder to know what you should be entering.
- Status
Similar threads
- Locked
- Question