Cell lookup

[Robert Couchman]

Hi,

Please can someone tell me how to get a Text 'Edit Box' to
get a value from a sheet in excel?

the Dialog box is being used in Excel, and i need it to
display this information when the Dialog is Run.

Thank you,

Robert Couchman

 

[Guest]

ControlSource property of the text box specifies which
cell contains data for the text dialog box.

 

[Tom Ogilvy]

Assuming you are using a DialogSheet and EditBox from the Forms toolbar, you
need to go to your dialog in the dialogsheet and select it. Right click on
the outline that surrounds the DialogSheet and indicates it is selected.
You should get a popup menu that includes
Assign Macro
as a choice.

Choose a macro like this:

Sub DialogFrame1_Show()
DialogSheets("Dialog1").EditBoxes("Edit Box 4").Text = _
Worksheets("A").Range("B2").Value
End Sub

This macro is assigned to the dialog frame and fires when the dialog is
displayed. You can initialize your editboxes here. The above macro should
already be in a general module before you perform the above steps to assign
it to the dialog frame.