Hi Andrew, I do not know if I can ever complete the whole course on the VBA that you shared, but every time I watch one of your videos I realize that you have really done a huge and fantastic work! I am convinced that there are people with an intelligence out of the ordinary and you are certainly one of those! You are a fantastic teacher! Thank you.
Wow-I have been pursuing this solution for configuring a multipage to open to the first page for a few months. I have tested some really wild suggestions; 30 - 40 lines of vb sometimes - and none of these performed accurately. Thank you so much. It would be cool to donate to your favorite charity in your name to thank you for sharing so freely this knowledge. Seriously, thank you and great success.
A trick I use to change the frame background is to set it to a very basic known RGB coded picture, made from an office object. You can specify the RGB colour and then put that into one of your colours. Only the tabs remain grey unfortunately.
Hi Andrew, I Think I have a better solution for the backcolor of the multipage (at 9 minutes). Just make a small white Jpeg with Paint, add this as picture to the multipage and select stretch for PictureSizeMode. Though I share this with your audience. Great video's btw, learnt a lot. Mayby you could help me with a question I have? Is it possible to built a class module, which activates on enter en exit events and change the backcolor off a control. At this moment I have to set this events for each separate control, which is a hell of a job. Hope you know a solution for this.
Hi teacher I have an issue .don't know if it is related only to multipage or even userforms The issue is that listview and listbox shifts (changes) it's position within the page in the multipage control and their related ckeckboxes become invisible If we leave the page and then come back to it until we check the checkboxe to make it visible again Is there any solution to this bug or problem ?? And thank you in advance
www.whatmarkdid.com/software/excel-vba-multipage-listview-bug/ www.mrexcel.com/board/threads/disappearing-listview-checkboxes-on-multipage.337574/ I hope it helps!
Thanks! You could loop through the controls (we covered that technique in this video th-cam.com/video/-AoF1wox6Tw/w-d-xo.html ) and check if the type of control is a combo box then if the combo box is empty. If both conditions are true, add 1 to a counter variable and display this at the end of the procedure. I hope it helps!
Hi Andrew, I do not know if I can ever complete the whole course on the VBA that you shared, but every time I watch one of your videos I realize that you have really done a huge and fantastic work! I am convinced that there are people with an intelligence out of the ordinary and you are certainly one of those! You are a fantastic teacher! Thank you.
@Jerry Harvey Thanks 😊
Wow-I have been pursuing this solution for configuring a multipage to open to the first page for a few months. I have tested some really wild suggestions; 30 - 40 lines of vb sometimes - and none of these performed accurately. Thank you so much. It would be cool to donate to your favorite charity in your name to thank you for sharing so freely this knowledge. Seriously, thank you and great success.
HI Wiseowl , i became VBA developer from your vedeos, thanks for sharing ..
This makes the form look so much classy! Thank you Andrew!!!
Thank-you Andrew. Multi pages is the way to go. :)
A trick I use to change the frame background is to set it to a very basic known RGB coded picture, made from an office object. You can specify the RGB colour and then put that into one of your colours. Only the tabs remain grey unfortunately.
That's a neat trick! Thanks for sharing that one, very useful!
A perfect video, again Thanks
Glad you liked it, thanks for watching!
Hi Andrew, I Think I have a better solution for the backcolor of the multipage (at 9 minutes). Just make a small white Jpeg with Paint, add this as picture to the multipage and select stretch for PictureSizeMode. Though I share this with your audience. Great video's btw, learnt a lot.
Mayby you could help me with a question I have? Is it possible to built a class module, which activates on enter en exit events and change the backcolor off a control. At this moment I have to set this events for each separate control, which is a hell of a job. Hope you know a solution for this.
Hello, nice video! Just one question, i didn't fid the option taborientation in the properties windows, is that something that needs to be activated?
Hi teacher
I have an issue .don't know if it is related only to multipage or even userforms
The issue is that listview and listbox shifts (changes) it's position within the page in the multipage control and their related ckeckboxes become invisible If we leave the page and then come back to it until we check the checkboxe to make it visible again
Is there any solution to this bug or problem ??
And thank you in advance
www.whatmarkdid.com/software/excel-vba-multipage-listview-bug/
www.mrexcel.com/board/threads/disappearing-listview-checkboxes-on-multipage.337574/
I hope it helps!
Amazing man, i want to have a message box telling how many comboboxes are empty before to continue. Any tip?
Thanks! You could loop through the controls (we covered that technique in this video th-cam.com/video/-AoF1wox6Tw/w-d-xo.html ) and check if the type of control is a combo box then if the combo box is empty. If both conditions are true, add 1 to a counter variable and display this at the end of the procedure.
I hope it helps!
How do you change background color of page tab? So that you can distinguish selected page from non selected ones?
I don't think that you can change the tab colour. You could try renaming the tab when it's selected, maybe make the text all caps for example.
Hello Andrew. I enjoyed your video tutorial on Excel VBA. I am an accountant. Would you like to share the finished file of this project....
How to search and update data multipage user form
Excelente!
C'est vraiment dommage que je ne suis pas anglophone. J'ai le sentiment que votre vidéo est excellente; mais...