Hi,

First post !


I'm referencing a cell on a worksheet that will return the string format of a User Defined Type (UDT)
However - because of the string data type this is pretty useless as I can't access the value associated with this UDT.

So - Ideally somehow I have to convert the string to a UDT format so that I can access its value as follows:

Dim nmUDT
nmUDT = Range("InputRecord").Offset(intWrite - 1, 0)

Any ideas on this ?

Much obliged

ArtWork

Maybe you could post some examples of input and desired output?

Tom,

I have dimentioned User Defined Types - for example:
[AV.Prepayment.DftLevel1]

I want to keep a list of all the UDT's in a spreadsheet and use them in a loop.
However - when I capture the UDT to a variable it comes through as a string and I can't see how to convert this back to a useable UDT

For example - I capture the value in the following cell to the variable.
[myVar=Sheets("InputRecord").Cells(1001, 6)]

The value in the cell is the UDT literal
[AV.Prepayment.DftLevel1]

myVar value is therefore a string
["AV.Prepayment.DftLevel1"]

My question - how do I capture this in the code again as a UDT and not as a string value of the literal UDT ?

I'm beginning to think it can't be done unless I write it all into the code in the VBE

excuse my ignorance on using qoutes etc on this site !

much obliged