Return the value from a text field in a dialog frame

mairead48

New member
Joined
Nov 17, 2013
Messages
1
Reaction score
0
Points
0
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
 
Top