Cell lookup
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 |
Cell lookup
ControlSource property of the text box specifies which
cell contains data for the text dialog box. -----Original Message----- 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 . |
Cell lookup
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. -- Regards, Tom Ogilvy "Robert Couchman" wrote in message ... 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 |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com