| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to xFer via VBA a VBA variable to Form
2003
With the Control ToolBox displayed on an "Sheet1," in the Design Mode, the "Formula Bar" displays =EMBED("Forms.TextBox.1",""). Currently, I have linked TextBox1 to cell M3. Therefore, when I enter text into M3, it is displayed in the TextBox1. Yes, I can "populate" TextBox1 in VBA by: sheets("Sheet1").Range("M3").value = txt ("txt" is a variable in a VBA procedure) How can I get the VBA variable directly into TextBox1? Under properties, I see separate "Text," "Value," and as mentioned above, LinkedCell dropdowns. Is there a way to populate TextBox1 directly in VBA? (without using LinkedCell = M3)? Like: ActiveSheet.Shapes("TextBox1").Value = "bbb" (if the Object/Method supported it) TIA EagleOne |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to xFer via VBA a VBA variable to Form
ActiveSheet.TextBox1.Text = "bbb"
txt = "bbb" ActiveSheet.TextBox1.Text = txt -- Allllen "EagleOne" wrote: 2003 With the Control ToolBox displayed on an "Sheet1," in the Design Mode, the "Formula Bar" displays =EMBED("Forms.TextBox.1",""). Currently, I have linked TextBox1 to cell M3. Therefore, when I enter text into M3, it is displayed in the TextBox1. Yes, I can "populate" TextBox1 in VBA by: sheets("Sheet1").Range("M3").value = txt ("txt" is a variable in a VBA procedure) How can I get the VBA variable directly into TextBox1? Under properties, I see separate "Text," "Value," and as mentioned above, LinkedCell dropdowns. Is there a way to populate TextBox1 directly in VBA? (without using LinkedCell = M3)? Like: ActiveSheet.Shapes("TextBox1").Value = "bbb" (if the Object/Method supported it) TIA EagleOne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
| Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
| Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| user form question: text box to display result | Excel Discussion (Misc queries) | |||
Linear Mode
