The checkbox control underneath, which is what we want. That way, you appear to click the image, but the click will "go" to The comments), set the Enabled property of both switches to False. To make things easier (Thanks Andy Pope, for the suggestion in.I changed the name of both Image controls, respectively to SwitchOnĪnd SwitchOff and placed them on top of each other, right on top of.Worksheet and choosing Copy, clicked inside the Picture property and I then copied one of the switches by right-clicking them on the.Next I added an Image control, set its border to be hidden and theīackcolor and BorderColor to Window background, BorderStyle to 0 - BorderStyleNone:.I dragged a checkbox control on my form (used a slightly larger.I repeated steps 4 to 6 for the black (filled) switch.I changed both Shape Fill and Shape Outline to green.I clicked the Shape Format contextual tab: This ensures the icon is converted to a grouped set of built-in.I selected both icons and clicked Insert, giving me this:.In the subsequent window, type "switch" in the search box, this.From the Insert tab of Excel, choose Insert Icon:.This is the standard look of a userform with a checkbox: Modern looking controls Checkbox alternative I set that to the darkest grey there is on the pallette (just because Calibri turns out slightly smaller than Tahoma, which is why I change that to Calibri, just because I like that better than the default Set to 0 - BorderStyleNone (this makes things like checkboxes and listboxesįlat rather than that old-school 3D effect) I set that to Window Background (which is usually white) rather than Here are the settings I use to make my forms look more modern: The default settings of a userform are used as a templateįor any new control you add to it, so you can save yourself a lot of time When you insert a new userform into your VBA project, the form is set Which contains both the old-school userform and the modern form. Here I show how we might createĪ more modern-looking user-interface by changing some properties of theįorm and by using some tricks. Really old-school if you don't do anything. That the standard design of the userforms you create with that editor look The Microsoft VBA editor was designed somewhere around 1996. Creating modern-looking userforms in VBA Content
0 kommentar(er)
