Run-Time Error 424

Logit · #1 11-28-2017, 08:59 PM

.
I made a few changes to the macro code regarding the MultiPage Control .. specifically relating to the referencing of each of the three sheets.

In the ResetButton_Click macro, edited this line:

Code:

 
    'Sets the OptionButton1 control as TRUE or selected upon opening.
    MultiPage1.Page3.OptionButton1 = True

In UserForm_Initialize macro, edited this line :

Code:

'Sets FOCUS to first page of multipage control when UserForm opens
Me.MultiPage1.Value = 0

The searchButton_Click() macro is not complete. It will need additional code.

The LoadDate macro will need attention as well, reference how the Text file is opened
and data retrieved.

Always use the phrase OPTION EXPLICIT at the top of all modules before you begin
entering code. It acts as an 'error checker', letting you know which lines have an error
and providing an error code for you to review. Oftentimes, it will make completing your

project occur in less time.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Run Time Error '1004'	galkej	Excel	0	02-03-2014 06:39 AM
Get Run-time Error 11	Jamtart	PowerPoint	2	08-31-2012 05:04 AM
Run time error 1004	yonasan	Excel Programming	3	06-12-2012 11:08 PM
Word Visual Basic error - run time error 504	crazymorton	Word	11	01-13-2012 04:32 AM
Run-time error 438	cksm4	Word	2	01-12-2011 03:41 PM