Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert combo box in a cell
I want to add a combe box to a whole chart, each line should have a combo
box. How can I insert in the cell the combo box? I have a long list and I need in each cell a combo box. It doesn't make sense to make in each cell seperatly a combo. Isn't there an easier way? Also how can I make, that after i pick an item from the combo box and press enter, it should go to the next cell? Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert combo box in a cell
Maybe you can use Data|Validation.
See Debra Dalgleish's site for lots of tips: http://contextures.com/xlDataVal01.html art wrote: I want to add a combe box to a whole chart, each line should have a combo box. How can I insert in the cell the combo box? I have a long list and I need in each cell a combo box. It doesn't make sense to make in each cell seperatly a combo. Isn't there an easier way? Also how can I make, that after i pick an item from the combo box and press enter, it should go to the next cell? Please help. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert combo box in a cell
No. I can't use data validation, for a few reasons. One of them because it's
a long list, and I want to be able to start typing in the first few letters, and the matching word should come up. please help. Thank You. "Dave Peterson" wrote: Maybe you can use Data|Validation. See Debra Dalgleish's site for lots of tips: http://contextures.com/xlDataVal01.html art wrote: I want to add a combe box to a whole chart, each line should have a combo box. How can I insert in the cell the combo box? I have a long list and I need in each cell a combo box. It doesn't make sense to make in each cell seperatly a combo. Isn't there an easier way? Also how can I make, that after i pick an item from the combo box and press enter, it should go to the next cell? Please help. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert combo box in a cell
Add a combobox from the control toolbox toolbar to your worksheet--set it up
exactly the way you like it. Set the .style, .listfillrange, all that stuff. Then you can use a worksheet_selectionchange event to move it close to your selected cell. Then rightclick on the worksheet tab and select view code. Paste this into the code window. Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) Me.ComboBox1.Visible = False With Target If .Cells.Count 1 Then Exit Sub If Intersect(.Cells, Me.Range("b:b")) Is Nothing Then Exit Sub Me.ComboBox1.LinkedCell = .Address(external:=True) With .Offset(0, 1) Me.ComboBox1.Top = .Top Me.ComboBox1.Left = .Left End With Me.ComboBox1.Visible = True End With End Sub my combobox was named combobox1 and I showed it when I selected a single cell in column B. And I showed it just to the right of that cell. art wrote: I want to add a combe box to a whole chart, each line should have a combo box. How can I insert in the cell the combo box? I have a long list and I need in each cell a combo box. It doesn't make sense to make in each cell seperatly a combo. Isn't there an easier way? Also how can I make, that after i pick an item from the combo box and press enter, it should go to the next cell? Please help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert a list in the ActiveX combo box | New Users to Excel | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
How do I insert combo drop box and still be able to sort? | Excel Worksheet Functions | |||
Why can't I insert a Combo Box in Excel? | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |