combo box

Mar 11th, 2002, 03:16 AM

i use a combo box in an excel worksheet.
How can i past a combo box in a cell so that when i chance the height or the width of the cell, also the measurements of the combo box changes.

Dave Hawley · Mar 11th, 2002, 03:58 AM

Hi

Assuming your ComBobox is already aligned with a cell, name the cell then use some code like:

Private Sub ComboBox1_DropButt*******()
With ComboBox1
.Width = Range("Mine").Width
.Height = Range("Mine").Height
.Left = Range("Mine").Left
End With
End Sub

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

Mar 11th, 2002, 03:16 AM	#1
Guest Posts: n/a	i use a combo box in an excel worksheet. How can i past a combo box in a cell so that when i chance the height or the width of the cell, also the measurements of the combo box changes.

Mar 11th, 2002, 03:58 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Assuming your ComBobox is already aligned with a cell, name the cell then use some code like: Private Sub ComboBox1_DropButt*******() With ComboBox1 .Width = Range("Mine").Width .Height = Range("Mine").Height .Left = Range("Mine").Left End With End Sub