View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bobby Bobby is offline
external usenet poster
 
Posts: 75
Default Cell Contents on UserForm

Hello
I have just started working with UserForms and I am trying to put the
contents of a cell on my form as a text box. I have found this question
asked here and this is the answer...

label1.caption = workbooks("myworkbook.xls").worksheets(1).range("a 1").Value

Where do I put this to get it to work.
I have created the example partsLocDB.xls as listed at
http://www.contextures.com/tiptech.html.

Can anyone reccomend further reccomendations for examples and help for
userforms?
Thanks!