View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KJ-clueless KJ-clueless is offline
external usenet poster
 
Posts: 5
Default 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?