Is there any way of getting a 'background picture' selected through the buttons properties to actually fill the button area completely rather than leaving a border around the edge of the button (which is really silly)?
Many thanks.
Is there any way of getting a 'background picture' selected through the buttons properties to actually fill the button area completely rather than leaving a border around the edge of the button (which is really silly)?
Many thanks.
No, not that I am aware of. (It may well be possible by using API calls to draw over the top of the button if you are really determined).
Remember what the dormouse said
Feed your head
Um, wouldn't know where to even start with that...
Thanks for your reply to my question. Seems a really stupid implementation of this feature to me or am I missing something?
It is what it is. Userforms are generally fairly basic in terms of appearance, but then functionality is more important anyway.
I guess, but no reason they couldn't consider the graphic aspect as well!
Very good reason - they want you to move to .Net and Windows Forms and all that good stuff.
I'm not sure if you are working on a userform or on a worksheet, but Image controls have a click event and an Image shape could be assigned to a macro.
I'm suggesting you use a control other than a CommandButton or a Forms Button (or an ActiveX Button).
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi Mike
I'm currently using a 'Toggle Button' on a worksheet because I need to use the True and False States to show/Hide a map. It makes no difference what kind of button, in fact I'd much rather use a Shape than a button, but these don't have True/False states (as far as I know).
This is my code thus far... Happy to look at other solutions if anyone knows how this can be done using a standard shape, from the Insert/Shapes Menu?
Please Login or Register to view this content.
You could use the text of a shape to store its "value"Please Login or Register to view this content.
Hi Mike
I couldn't get that to work for some reason...
I tested that routine by creating a new workbook, adding a Rectangle to the sheet (not SmartArt) and assigning that macro to the Rectangle.
Here's a sheet with a button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks