Excel/VB EditBox: assigning variable name to inputs
Posted on 1997-08-19
I have created a DialogBox with a number of different EditBoxes. In these EditBoxes, I wish to input data to which I would like to assign a variable name, later to be used in my code. What I have written so far looks as below (if I could get it to work, I'd be set,since this code would mean that I have successfully assigned EditBox inputs to a variable).
> DialogSheets("Dialog1").EditBoxes(1).Text = 100
> DialogSheets("Dialog1").EditBoxes(2).Text = 12
> Set iterations = DialogSheets("Dialog1").EditBoxes(1)
> Sheets("Assumptions Sheet").Activate
> Range("A13").Value = iterations
> End Sub
My problem is that the DialogSheets object does not support the Value property -- how can I get around this?
With kind regards,