how do I insert a variabel into a textbox

dh_ander

Board Regular
Joined
Jul 31, 2006
Messages
119
somewhere in my code I declare a public variabel say:
public variabel as string

on one of my forms I want on opening this for to show this variabel
say : Form = frmMain
what do I write in standarvalue for my textbox or in VBcode for this object

Code:
Private Sub NaamDumpACL_BeforeUpdate(Cancel As Integer)
   ???????????
End Sub

thanks in advance
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
Once you've defined your variable as public....
Public MyTest as String

You need to assign something to your variable....
MyTest = "Testing1..2..3"

Then in the On Open Event of your form, you simply enter....
Me!NameofFieldUWantVariableToFill = MyTest

When you open the form, whatever field you pointed to will contain... Testing1..2..3
 

dh_ander

Board Regular
Joined
Jul 31, 2006
Messages
119
Thanks for the reply I am almost there

I have some some problem with my public variabel, but I should be able to fix that.

Have a great weekend
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,638
Members
410,805
Latest member
Ginoji
Top