Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo boxes again
I am using a combo box to enter data into an offset cell to the active cell.
I can type free text into the combo box but cannot get it to enter when I click the box (which activates the sub to enter the data) into the offset cell! I suspect this is because it doesnt count this as a click event? My sub for entering text is as follows: Private Sub ComboBox1_Click() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim Newvalue, d With Worksheets("Main Board") c = .Range("D82").Value ActiveCell.Offset(c, 0).Value = ComboBox1.Value ComboBox1.Value = "" End With ComboBox1.Visible = False Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub any Ideas anyone ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
Combo Boxes and Tick Boxes | Excel Programming |