'Userform multipage does not refresh / work
I'm pulling my hair on this one
I'm working on VBA application that consists of few pages on multipage. I have a list of items on page 0 and when I click on that item, excel then should move to different page. the code I have is:
Userform1.MultiPage1.Value = 1
This however does not happen. I mean the page 1 is not shown even though it is selected (tab on top of the multipage is selected).
I have quite a bit of code prior to above shown code and everything seems to be working fine.
I have read on google that the problem could be due to declaring the same variable more than once. Code checked and looks ok now.
I also read that the form can be corrupted. I hope it isn't because there is a lot of stuff on it.
Dear brothers! Do you have any idea why the multipage doesn't change the page and how to fix it.
This is very important to me because I have to show working draft tomorrow at work :/
Thank you in advance.
On attached picture you can see that the multipage has changed from 'page1' to 'video_exhibit', however it did not update the view. just stayed on the same page. Multipage was working fine prior to this stage of the application.
I hope admins are ok with it. I shared the files on google drive at https://drive.google.com/drive/folders/12LTuaMoQ-HpI1z8g9F2419dHvHQU4f_4?usp=sharing uploaded are: rar, zip and exports from app. userform and modules. If anyone can help I'm willing to pay £10 for given charity. I guess paying someone directly isn't allowed. I just need this problem fixed. I'm aware there is lots to fix and unnecessary loops, but this can wait as I just need a draft working. Once again, thank you
Solution 1:[1]
Ladies and Gents!
thank you for your help.
So, after spending whole night trying to fix it, I decided to create new Userform and copy all the stuff on it. It works!
I've asked if the problem could be due to file being corrupted and it looks like this was the reason. Userform1 was behaving strangely and I could not understand it.
So unless someone will find different reason for the bug, the official version is - Userform1 was corrupted.
Regards
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | lukdymek |
