View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tenglins@gmail.com is offline
external usenet poster
 
Posts: 1
Default showing data from a cell in a text box

I put together a userform that saves a copy of a file while keeping the
file open. I create the filepath for this archive copy by getting user
inputs fromt the form. I want to display the full filepath of the
archive workbook in another userform after the user pushes the save
button in my first user form.

How do I get the filepath (a merged string of information) to show up
in this second user form textbox without changing the source.

The file path is in sheet2, c1