Hi
I've small query regarding usage of Multipage
There is an issue when Userform is initilaized eventhough you set a Page value to a default
The above MultiPage1.Value = 0 will be default whether the userform in Coding Enviorment displaying Multipage value = 1
With above statement scenario
The issue was observed when combobox1 did not display its items the values when MultiPage1.Value = 0. from above multiPage1_Change event when form was intialized.
I had to click both the Tabs of Each Page to get its proper functioning
In anticipation of above issue then there could be more things croped up with clicking on Tabs of each page for proper functioning
Any other methods for proper result apart from all the combboxes1 and 2 with text property and .Additems incorporated in UserForm_Initialize Event
NimishK
I've small query regarding usage of Multipage
There is an issue when Userform is initilaized eventhough you set a Page value to a default
VBA Code:
Private Sub UserForm_Initialize()
Load uf1
MultiPage1.Value = 0
End Sub
Private Sub MultiPage1_Change()
Select Case MultiPage1.Value
Case Is = 0
combo1.Text = "Rate % [+]"
combo1.AddItem "Rate % [+]"
combo1.AddItem "Rate % [-]"
Case Is = 1
combo2.Text = "Rate % [+]"
combo2.AddItem "Rate % [+]"
combo2.AddItem "Rate % [-]"
End Select
End Sub
The above MultiPage1.Value = 0 will be default whether the userform in Coding Enviorment displaying Multipage value = 1
With above statement scenario
The issue was observed when combobox1 did not display its items the values when MultiPage1.Value = 0. from above multiPage1_Change event when form was intialized.
I had to click both the Tabs of Each Page to get its proper functioning
In anticipation of above issue then there could be more things croped up with clicking on Tabs of each page for proper functioning
Any other methods for proper result apart from all the combboxes1 and 2 with text property and .Additems incorporated in UserForm_Initialize Event
NimishK
Last edited: