I'm not exactly sure how to explain this, but I currently have a sub that calls UserForm_Initialize() because I couldn't get my combo boxes to reload everytime something was added or deleted. So I called the sub, and this reloaded them for me.
But then I was having the problem of my 2nd tab always displaying first when I did userform.show so I had to use MultiPage1.Value = 0
Now, when I delete something (which is located on the second tab), it calls userform and shows the first tab.
is there a way to specify certain things to happen upon which sub is doing the calling?
For instance: If I press my delete button, can it call the user form but display tab 2? and if I press the, say, 'load form' button, can it call the user form but display tab 1?
I'm not sure if this makes sense
but here is the code that I am using. (OR, is there someway to reload my combo boxes without calling UserForm_Initialize)
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks