Get instant live expert help on I need help with vba string functions
“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 need help with coding VBA and getting a commandbutton to have multiple functions
Solved by A. B. in 18 mins
Hey I need help with VBA. The first functions that you will create are helper functions that can be used by otherfunctions. Function FindMax(valueArray, nameArray) As String This function takes in two arrays; the first array has the numeric values while thesecond array has the names. The function will find the value in the first array that isthe largest and return the corresponding name (from the second array). For instance, if the valueArray = (10, 20, 5, 9) and nameArray is (House, Chair, Table, Book). The function will return Chair.
Solved by F. A. in 24 mins
In excel VBA I have a sub that takes in 3 variables and in running the code generates 5 new variables. I would like to 5 either a single function or 5 different functions to return each of these variables without having redundant code where I have to repeat the same code in all 5 functions. See example below for my sub code: Sub MySub(Input1 as Integer, Input2 as Integer, Input3 as Integer) Dim Output1 as Integer Dim Output2 as Integer Dim Output3 as Double Dim Output4 as Double Dim Output5 as String MyVBACode EndSub
Solved by V. B. in 23 mins
I am having trouble writing VBA functions in my excel file to add the functionality of hiding certain columns based on particular cell selection. Is this something you can assist with?
Solved by V. Y. in 23 mins
excel functions excel functions excel functions excel functions excel functions excel functions
Solved by E. H. in 13 mins