Menu

Initializing UserForm which uses MultiPage controls, part 2

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Tom Ogilvy Tom Ogilvy is offline

Tom Ogilvy is offline

external usenet poster

Posts: 27,285

Default

Initializing UserForm which uses MultiPage controls, part 2

--
Regards,
Tom Ogivly

"Patrick Simonds" wrote in message
...
I posted the question below earlier, and both Tom Ogilvy and Dave Peterson
were kind enough to reply. Unfortunately their solution did not work. In
the interest of brevity in my prior post I am sure that I could have
provided more useful information. I was going to attch the workbook, but
could not get it down to a small enough size to send to the newsgroup. I
would be more than happy to e-mail this out if someone would be willing to
take a look.

I am having a problem Initializing my UserForm which has on it 2 MultiPage
controls. Before I added the second MultiPage control (which is located on
Page2 of MultiPage1) everything worked fine. Now when I try to open the
UserForm I get Object not found errors. I assume I must some how account
for the second MultiPage control in the "With" statement, but nothing I
have tried works.

With Me.MultiPage1
.Value = .Pages(myMPPageName).Index
End With

Private Sub UserForm_Initialize()

'This macro intializes the Data Input UserForm

With Me.MultiPage1
.Value = .Pages(myMPPageName).Index
End With

'Populates the End of Period Data on MultiPage1

TextBox1.Text = Worksheets("Audit Report Page 1").Range("E4").Text
TextBox2.Text = Worksheets("Audit Report Page 1").Range("E7").Text
TextBox3.Text = Worksheets("Audit Report Page 1").Range("E8").Text

'Populates Outstanding Checks on MultiPage1

TextBox8.Text = Worksheets("Outstanding Checks").Range("A5").Text
TextBox9.Text = Worksheets("Outstanding Checks").Range("B5").Text
TextBox10.Text = Worksheets("Outstanding Checks").Range("C5").Text

'Populates January Income on MultiPage2

TextBox80.Text = Worksheets("Income").Range("B3").Text
TextBox81.Text = Worksheets("Income").Range("C3").Text
TextBox82.Text = Worksheets("Income").Range("D3").Text

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Initializing UserForm which uses MultiPage controls	Patrick Simonds	Excel Programming	6	August 15th 06 02:42 AM
stop userform from initializing	JT[_2_]	Excel Programming	3	March 4th 05 07:18 PM
How to loop through controls on a MultiPage	42N83W	Excel Programming	11	February 14th 05 11:32 PM
Initializing Combobox in a Userform	Neal[_5_]	Excel Programming	2	September 15th 04 12:19 AM
Initializing Userform	Szadkowski	Excel Programming	1	August 31st 04 12:35 AM

All times are GMT +1. The time now is 03:46 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement