Userform Multipage Show method 'object required' error

[DutchWard]

Hi guys,

I'm quite new VBA coding, and particularly to coding for UserForms. I'm trying to make a UserForm tool to enter information into a database. I have created a number of UserForms which I want to link with buttons such as Next or OK. The .Show method works fine for most UserForms I have made. But, there is one with a Multipage on it and when I use the .Show method I get a run-time error '424' object required. Below is the code I have used.

Unload BankSelectionForm


GeneralInformationForm.Show

GeneralInformationForm is the correct name and spelling because I copied the name over. I have also tried the following:

With GeneralInformationForm
    .MultiPage1.Value = 0
   .Show
End With

I read in a post somewhere that this could help. But it doesn't. I get the same error. I have also tried declaring and setting GeneralInformationForm, but maybe I'm doing something wrong, and I didn't do it for other UserForms and they work, so I'm not sure it's even necessary.

Any help would be greatly appreciated!

 

[tygrrboi]

Try putting .Show first

Also you can change the MultiPage settings in a UserForm_Initialize() event

 

[DutchWard]

Hi Tygrrboi,

Thanks for your quick reply. I hadn't tried that yet. Just tried it now, but I still get the same run-time error 424 object required.