combo box arrow

cpc

New Member
Joined
Mar 14, 2002
Messages
38
Is it possible to move the arrow in a combo box to the left side of the box instead of the right? (no VBA please)
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
This may work for you. Put a combobox in and adjust the size so that you only see the arrow. Now put a textbox on the right side of keeping the proportions similar. Now link the data selection in combobox to the list box.
VBA: TextBox1.Text = ComboBox1.Text
Just an idea.
No VBA then use linked cell= to point to a cell in worksheet for both boxes.
This message was edited by d-alan on 2002-03-27 14:42
 
Upvote 0
Just to add to JSW's reply. There's no way to change this without VBA. I just checked in Dan Appleman's Win32 API guide (which describes practically every possible thing you can do to a combobox) to see if it could even be done through VBA and there's nothing there - sorry.

Regards,
D
 
Upvote 0

Forum statistics

Threads
1,214,415
Messages
6,119,382
Members
448,889
Latest member
TS_711

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top