View Single Post
 
Old 11-28-2017, 08:59 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
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.
Attached Files
File Type: xlsm HW5_FP01_Chase_Lynch.xlsm (27.9 KB, 14 views)
Reply With Quote