How to xFer via VBA a VBA variable to Form

E

EagleOne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=DATE() function in VBA? 3
VBA beginner needs assistance with ComboBox in a User Form 2
VBA: how to get variables into querry code 2
Need help in printing vba code 0
VBA-Remove paragraph marks in a textbox 4
using VBA to populate a hyperlink field 2
Importing from a Form 2
Global variables lost when opening a VBA-generated form. 4

Top