Passing variable values to userform control
I am running some code to loop through files. I want to pass the file name
being examined to a textbox on a userform. I am not familiar with
referencing these objects in Excel VBA.. rather easy but different in Access.
Can any one help?
I would do it this way in Access:
forms!frm_whatever!txtbox1.value = varname
how do I do this in Excel?
|