i have a cmb1 on column C
i wana change the size of combobox with column size :wave:
Printable View
i have a cmb1 on column C
i wana change the size of combobox with column size :wave:
Right-click it, choose Format Control. Go to Properties tab and choose Move and size with cells.
zaza
ya it working fine
how the selected item from the combo box , will apear on cell
how the combox will invisible after item select
on cell click combo will apear otherwise remain invisible
plz help
I think this is what you are asking for.
VB Code:
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
thankx
ya it working fine for one cell
if i have combobox on many cells like C1,C2,C3,A1,A2, than what
Many combos will require many evaluations.
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
ya this methodis working fine