Learn How to use VBA uBound in Excel
Ok. Lets assume we have a variable called MyVariableTest which is of the data type string.
below is the code...
'Code starts below
'Here is how we define this variable
Dim MyVariable1 As String
' Now get a value assigned to the varible
MyVariableTest = "My Variable Test"
' Now lets split this text using the delimiter " " - space
' this split action will help me separate the three text
' elements i.e. My, Variable, Test
'we would need to put the splitted value in a new variable
MySplittedArrray = Split(MyVariableTest, " ")
' Now MySplittedArrray has the three text elements stored in an
' arrary which is MySplittedArrray
' You would use uBound VBA property to get the last text element
' And you would use lBound VBA property to get the first one
' so if you want "Test" as your output use uBound if you want
' "My" as your output use lBound
' uBound will give you the number of elements the main string was broken into after the split. Note that array counting start with 0 so in this case uBound will return you 2
' Now simply return it
' this will output 2
' if you want to use UBound to Print Test
' use the statement below...
' this will output Test
'Code ends here
If you like this post do let me know and feel free to comment.