Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
return UDT element to spreadsheet cell
Using Excel 2003.
I have a module with the following code: Type ValUnit tValue As Double tUnit As String End Type Function SeparateValueFromUnit(ByVal strInput As String) As ValUnit Dim fromwhere As Integer fromwhere = InStr(trim(strInput), ".") + 4 SeparateValueFromUnit.tValue = Left(trim(strInput), fromwhere) SeparateValueFromUnit.tUnit = Mid(trim(strInput), fromwhere + 1) End Function If I go to the immediate window and enter: ? separatevaluefromunit(" 49.0000RLS").tunit I get the correct response. If I go to a cell in the worksheet and enter: (H2 Holds " 49.0000RLS") =SeparateValueFromUnit(H2).tUnit I get an error: "The formula you typed contains an error". How do I return just one element (tUnit, or tValue) to this cell? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return multiple vales from a different spreadsheet into one cell | Excel Discussion (Misc queries) | |||
Rules for element-by-element product in array multiplication | Excel Programming | |||
How to return to a cell after sorting a spreadsheet. | Excel Worksheet Functions | |||
How to "return" the array element number in VBA | Excel Discussion (Misc queries) | |||
Search array and return element No | Excel Worksheet Functions |