vbcoder2012
Programmer
I am passing the value of an array to a textbox, but it always turns up empty. When i pass the same value to an excel cell, i get the value. The function calculates the value of USCityA
I am giving parts of the code below:
Redim Pline(9)
Pline(9) = USCityA
test = "Hello"
USA = test & Pline(9)
In another sub, i call this funtion above to allocate the value of USC to the city as shown below:
CityA = USA
Activesheet.OLEobjects("txtbCityA").Object.Value = "CityA:" & CityA
The value i get in my textbox is only "Hello". When i pass USA to an excel cell, i get "Hello Fortworth" (or whatever the value of "USA" is calculated in the function)
I am giving parts of the code below:
Redim Pline(9)
Pline(9) = USCityA
test = "Hello"
USA = test & Pline(9)
In another sub, i call this funtion above to allocate the value of USC to the city as shown below:
CityA = USA
Activesheet.OLEobjects("txtbCityA").Object.Value = "CityA:" & CityA
The value i get in my textbox is only "Hello". When i pass USA to an excel cell, i get "Hello Fortworth" (or whatever the value of "USA" is calculated in the function)