Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Am trying to get a combo box to keep adding its selected contents to a cell
(actually to an offset cell) have used this sub successfully with a set list fill range but as soon as I use a variable range it becomes circular and just keeps adding and adding to itself etc! how do I make a cell = itself plus another cell once only per combo box click? Private Sub ComboBox54_Click() With Worksheets("Main Board") Set c = .Range("D82") ActiveCell.Offset(c, 0).Value = Range("I86") + ActiveCell.Offset(c, 0).Value Range("I86") = " " End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 | |||
List boxes/combo boxes | Excel Programming |