Change the look of a Control Module ComboBox

[aRush113]

Hello,
I was wondering if it's possible to change the look (Shape, Color, etc...) of a Control Module ComboBox from the standard (boring) one.
Thanx.

 

[Micron]

AFAIK, all you can do is combine a listbox and a command button. Based on a trick I've used in Access:
The button could look like normal, or use larger ones with embedded image. The listbox height would be one row to start with. Button click "drops" (actually, expands vertically) the listbox. The height increase is based on the list row count. An advantage to doing this is that a listbox can have formatted fonts, and you can place the button on either side or across the top. You can also use labels (thus colour them) as buttons. You'd want to cycle the label's raised and sunken appearance to simulate pressing down a button, but that's a lot of code for very little payback. I've never tried to do this in Excel but I suspect it's possible.

 

[aRush113]

Thanx for the reply Micron.
I thought it wouldn't be possible. Go figure, they make almost every object customizable except the one i need.
I guess i'll try your suggestion and see what i come up with.
Thanx again and a happy New Year to you and all the great people on this forum.

 

[Micron]

I did some research and found that you have to put the listbox in a frame. The frame width can cut off the scroll bar on the right. Getting rid of the bottom scroll bar requires that the column width(s) (in points) x column count is less than the listbox width, or I suppose you can also accomplish that with the frame height. When you reduce the height to one list row you may find that the top list item is selected. To get rid of the background colour you can use something like
userform.ListBox3.ListIndex = -1. After about an hour of researching and playing with control properties I came up with this when the frame height is 20

I'm not seeing any real payback for all that work. Over the years I've come to learn that while creating eye candy can be fun it's seldom worth the effort. Plus, all that effort involves code that your successors likely can't maintain. Or IT bans vba. Or the application is updated and breaks your code. Or...
Have fun though!

 

[aRush113]

My thoughts exctally, the effort is not worth the time. I gave up after 10 minutes of trying to find a way of obtaining something worthwhile. I'm surprised, and thankful, you spent an hour on the subject. It was more a curiuosity than actual intrest on my part.
Sorry for waistng your time.
Thanx again.
I think it's appropriate to close this thread.

 

[Micron]

I learned something, and that is never a waste of time!

 

[smozgur]

I think it's appropriate to close this thread.

Threads are not closed in the board, there is no such mechanism. However, we mark a post as solution to help the future readers of this question. If there is an answer that you believe helps with the question, even a bit when there is not an exact solution (even saying "it is not possible" could be an answer btw), or if you post your own answer, then that would be great to see it marked it as the solution.
I would normally select post #2 as the best response to this question, however, I won't switch it, but leave the decision to you.
However, if you believe there is no post related to the solution then please do not mark any post.

 

[aRush113]

Threads are not closed in the board, there is no such mechanism. However, we mark a post as solution to help the future readers of this question. If there is an answer that you believe helps with the question, even a bit when there is not an exact solution (even saying "it is not possible" could be an answer btw), or if you post your own answer, then that would be great to see it marked it as the solution.
I would normally select post #2 as the best response to this question, however, I won't switch it, but leave the decision to you.
However, if you believe there is no post related to the solution then please do not mark any post.

Sorry, my bad.
I think i changed it. Could you check? thanx.

 

[smozgur]

I think i changed it. Could you check? thanx.

Thanks.