Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox positiion
Cell a1 contains a value indicating a particular row. I wish my combobox to
appear on that row in column "b" using vba. Sunil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox positiion
Assuming you got your ComboBox from the Control Toolbox toolbar and that its
name is ComboBox1, use this worksheet Change event code... Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(0, 0) = "A1" Then With ActiveSheet .OLEObjects("ComboBox1").Left = .Columns("B").Left .OLEObjects("ComboBox1").Top = .Rows(Range("A1").Value).Top End With End If End Sub Just enter a number in A1 and the ComboBox should move to the correct row. -- Rick (MVP - Excel) "sunilpatel" wrote in message ... Cell a1 contains a value indicating a particular row. I wish my combobox to appear on that row in column "b" using vba. Sunil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
Combobox options based on the input of another combobox | Excel Programming | |||
ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming |