combo box arrow

cpc · Mar 27th, 2002, 08:45 AM

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)

Joe Was · Mar 27th, 2002, 09:37 AM

No

cpc · Mar 27th, 2002, 03:01 PM

Is there any way to move the arrow on the combo box to the left?

Joe Was · Mar 27th, 2002, 03:16 PM

Not that I know of? JSW

d-alan · Mar 27th, 2002, 03:25 PM

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 ]

dk · Mar 27th, 2002, 03:27 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 08:45 AM	#1
cpc New Member Join Date: Mar 2002 Posts: 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)

Mar 27th, 2002, 09:37 AM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	No

Mar 27th, 2002, 03:01 PM	#3
cpc New Member Join Date: Mar 2002 Posts: 38	Is there any way to move the arrow on the combo box to the left?

Mar 27th, 2002, 03:16 PM	#4
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	Not that I know of? JSW

Mar 27th, 2002, 03:25 PM	#5
d-alan Board Regular Join Date: Mar 2002 Posts: 119	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 ]

Mar 27th, 2002, 03:27 PM	#6
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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