Get instant live expert help on I need help with excel vba select case
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I'm trying to work in VBA to pull data and run a calculation based on a selection. I'm using getbeta to retrieve the calculation based on the selection and a function to run the calculation. This is what I've written that gives me a null value: Function GetBeta(FA As Double, SoilType As String) As Double 'Calculate the Beta Coefficient based on Friction Angle and Soil Type Select Case SoilType Case SoilType Is "Clay" Select Case FA 'Use Clay Curve Case Is < 25: GetBeta = 0.23 Case 25 To 34: GetBeta = GetBeta = 0.0147 * Exp(0.1101 * FA) Case Is > 34: GetBeta = 0.5 End Select End Function
Solved by Z. L. in 22 mins
VBA code to select slicer selection via single cell
Solved by I. J. in 28 mins
I cant select to insert a userform in vba
Solved by B. U. in 12 mins
I am programming vba code in excel and i have list box edit like super market program select item and qty and amount then next line
Solved by O. H. in 29 mins
How can I fold text from upper case to Title Case in an EXCEL cell/workbook?
Solved by T. J. in 17 mins