I have created textbox1 on an excel spreadsheet and placed a number in it. I have written a function to get that number into an excel cell:

Public Function GetValue(Obj as Object)
Dim x as String

x = Obj.Value
GetValue = x
End Function


then in excel cell I call function:

=GetValue(TextBox1)

I can't get this work and feel I must be missing something pretty basic. It would be very valuable to be able to place data in textboxes, comboxes, etc. and then reference that data in excel functions for use use in excel formulas.
Regards, Dennis