UserForm

[wbromberek]

I have a UserForm with TextBox(about 70 of them) The user input the data into TextBox & when finished clicks the Enter (cmButton1), which then enters the infomation into worksheet cells. A message box comes up and asks if there is more input, if Yes another UserForm Opens,(this is similar to the 1st UserForm just smaller), if No then UserForm hides. I then save the Workbook. When I reopen Workbook and click for UserForm how can I save original information entered without reentering it? Any help?
Bill

 

[Ivan F Moala]

On 2002-04-27 16:30, wbromberek wrote:
I have a UserForm with TextBox(about 70 of them) The user input the data into TextBox & when finished clicks the Enter (cmButton1), which then enters the infomation into worksheet cells. A message box comes up and asks if there is more input, if Yes another UserForm Opens,(this is similar to the 1st UserForm just smaller), if No then UserForm hides. I then save the Workbook. When I reopen Workbook and click for UserForm how can I save original information entered without reentering it? Any help?
Bill

In your Userform initialise routine
just do the revere of your command button
routine ie. Assign the Textbox to the range
you assigned your Textbox to update with.

eg Textbox1.text = range("A1").text

 

[Todd_M]

What do you mean by saving the original info? Its already saved on the spread sheet that you posted it to. If your asking how would you view it then use Ivan's method.