Erdin? E. Ka
12-03-2006, 08:44 AM
Hi everyone, :hi:
I have to ListBox Control on Sheet1. I tried get their value to a cell via formula but i couldn't solve it. :dunno
=EMBED("Forms.ListBox.1";"")
Is there a way to get a page control's value via formula?
If this is impossible;
Can we coding for an UDF for all control types ?
Example syntaxs:
=GET_PAGE_CONTROL_VALUE("FullNameOfWorkBook","NameOfWorkSheet","NameOfControlType")
=GET_PAGE_CONTROL_VALUE("C:\Test.xls","Sheet1","ListBox1")
=GET_PAGE_CONTROL_VALUE("C:\Test.xls","Sheet1","ComboBox1")
=GET_PAGE_CONTROL_VALUE("C:\Test.xls","Sheet1","TextBox1")
I attached my file.
Thanks in advance.:friends:
I have to ListBox Control on Sheet1. I tried get their value to a cell via formula but i couldn't solve it. :dunno
=EMBED("Forms.ListBox.1";"")
Is there a way to get a page control's value via formula?
If this is impossible;
Can we coding for an UDF for all control types ?
Example syntaxs:
=GET_PAGE_CONTROL_VALUE("FullNameOfWorkBook","NameOfWorkSheet","NameOfControlType")
=GET_PAGE_CONTROL_VALUE("C:\Test.xls","Sheet1","ListBox1")
=GET_PAGE_CONTROL_VALUE("C:\Test.xls","Sheet1","ComboBox1")
=GET_PAGE_CONTROL_VALUE("C:\Test.xls","Sheet1","TextBox1")
I attached my file.
Thanks in advance.:friends: