View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel CHEN
 
Posts: n/a
Default Displaying cell values in a Userform


The same way as

TextBox.Text = ActiveSheet.Range("A1")
OR
TextBox.Text = Sheets("shtname").range("A1")

-
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"michaelberrier" wrote in message
ups.com...
I know how to configure a UserForm to display values from a textbox in
a specific cell:

ActiveSheet.Range("A1") = TextBox.Text

What I would like to do is the opposite. To design a macro that
displays specific cell values in the textboxes of a UserForm that pops
up.

Any hope of that?

Thanks to all.