View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jelso Jelso is offline
external usenet poster
 
Posts: 2
Default UserForm_Initialize? How to update.

Question: If I use UserForm_Initialize when calling up a form with
text boxes, the text boxes won't update if their source cells change.

Is there some other word/commmand I should use instead of "Initialize"
to have the text boxes update with new data? Or is the problem
elsewhere?

Thanks..SJ

------------------------------------
Private Sub UserForm_Initialize()

Title.Text = Range("C1").Value

SAMTitle.Text = Range("E3").Value
SAM1.Text = Range("E4").Value
SAM2.Text = Range("E5").Value
-----------------------------------