Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to lookup data in cell NEXT to another cell | Excel Worksheet Functions | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Need to lookup value in cell, dependent on value in another cell | Excel Worksheet Functions | |||
formatting a cell the same as the source cell from a lookup table | Excel Discussion (Misc queries) | |||
lookup more than one cell | Excel Worksheet Functions |