[RESOLVED] change the size of combobox with column size

[pandey_om]

i have a cmb1 on column C
i wana change the size of combobox with column size

[zaza]

Right-click it, choose Format Control. Go to Properties tab and choose Move and size with cells.

zaza

[pandey_om]

ya it working fine
how the selected item from the combo box , will apear on cell

[pandey_om]

how the combox will invisible after item select

[pandey_om]

on cell click combo will apear otherwise remain invisible
plz help

[RobDog888]

I think this is what you are asking for.

Option Explicit
'Behind sheet1 with a Combox1 residing in Cell A1
Private Sub ComboBox1_Click()
    ComboBox1.Visible = False
End Sub
 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If ActiveCell.Address = "$A$1" Then ComboBox1.Visible = True
End Sub

[pandey_om]

thankx
ya it working fine for one cell
if i have combobox on many cells like C1,C2,C3,A1,A2, than what

[RobDog888]

Many combos will require many evaluations.

[zaza]

Are you aware that, with a cell selected, you can go to the Data menu, choose Validation and select the List type. Then, in the Source box, you can select a range from the spreadsheet and this will give you something like a combobox in the cell without having to use the object.
From the sounds of it, this would be more up your street.

zaza

[pandey_om]

ya this methodis working fine