View Single Post
 
Old 09-15-2021, 06:19 PM
James Martin James Martin is offline Windows 10 Office 2019
Novice
 
Join Date: Sep 2021
Posts: 7
James Martin is on a distinguished road
Default Good tutorials for ListBox /CombiBox (tweaking MsgBox)?

I've Got a simple VBA code from here, to rotate inlineshapes, either selected, or all in Word document. Looking for an easy to follow tutorial to select the rotation value of either -90°, 90° or 180°. (you can only apply rotation once via macro).I will want to add the variable of selected or all with Combibox, but struggling to get ListBox to work first. I have just found this link to tweak MsgBox:

https://wellsr.com/vba/2019/excel/create-advanced-vba-msgbox-custom-buttons/

so will try it, but may not be able to have 5 buttons, and I can't use unecessary code when rolling out to colleagues. Does anyone else have a simpler tweak of MsgBox?

Need to understand ListBox and CombiBox. All the online searches are for Embedded within Excel which I don't want to do.
Reply With Quote