MULTI-PAGE CONTROLS - CAN THEY BE USED TO UPDATE A WORKSHEET?

Posted by Montgomery on August 24, 2001 11:07 AM

Hi experts,

I have this huge worksheet with about 40 columns. This has to be used by an overseas agent to input information and updated by myself to our files. the form is too small to hold all the controls and i was wondering if a multi-page control with 3 pages could work. If it can work can anyone tell me how I can get the data to be updated after inputting info on the last page?

Waiting anxiously for some help.

Faith

Posted by Damon Ostrander on August 26, 2001 5:46 PM

Hi Faith,

Yes, it is quite easy to update worksheets with information from multipage controls. For example, the VBA code to put the text from TextBox30 on the third page of MultiPage1 into cell B25 on the active worksheet:

[B25].Value = MultiPage1.Pages(2).TextBox30.Text

Note that it refers to Pages(2) rather than Pages(3) because the page numbering starts with 0. This code would probably be in your OK button (or whatever button you use to load the data from the form to the worksheet) click event before the userform is unloaded.

Happy computing.

Damon