VBA-Modern-Userform
VBA-Modern-Userform copied to clipboard
Error '5'
Hi,
I downloaded the GridBox.xlsm file, and when I launch the UserForm, and play arround it, it crashes with the error '5' Invalid procedure call or argument.
I notice that the bugs appear when I click on a tile. Using debug.print I noticed that it crash when the line " RaiseEvent TileBlured(Tile(Temp)) " is invoke, and the value of "temp" is equal to a value that is not on the screen. For example, if in the main section there are only file called "main_1, main_2..." and in the tool section "tool_1,tool_2..." and if I click on main_1, then on tool section, then on tool_1 it crash, because temp = main_1.
I fixed it adding :
Grid.ActiveTileName = "" in the SidebarGrid_TileClicked function
Thanks