I am using Excel 2010, and have an Excel Dialog Frame in which I have inserted a text field (from form controls, not activex controls, as activex controls are disabled for some reason.) I want the text that is input in the text field to appear in a cell. Unlike with option buttons, there doesn’t seem to be a cell link, so I am doing it in code. But I can’t seem to return the value of the text field. It is called EditBox1. After activating the sheet, I have tried all of the following (found in various forums) but none work. This should be basic, but I have spent hours on it now. Any ideas gratefully received.
ActiveSheet.EditBox1.Value
ActiveSheet.Shapes.EditBox1.Value
Me!EditBox1.Value
ActiveSheet.EditBox1.Value
ActiveSheet.Shapes.EditBox1.Value
Me!EditBox1.Value