Get instant live expert help on I need help with select case vba

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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
I need that when i select any cell from a row, a complete row would be highlighted. Hope so, It is possible with the help of VBA.
Solved by T. S. in 27 mins