![]() unfortunately the following lines don't work: cb. That's why I thought to use the linkedCell property. The problem is that I would like the cell below (the one 'covered' by the combobox) get the value selected in the combobox. Which adds an ActiveX combobox each time I press on a Cell in the 'A' column. ![]() Make sure that you have configured your Excel, that the 'Developer' tab is shown in the ribbon. First launch Excel and create a new document or open an already existing document. Set cb = Worksheets("FT_CASE_xx").OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, DisplayAsIcon:=False, Left:=Target.Left, Top:=Target.Top, Width:=Target.Width, Height:=Target.Height).Object Excel 2007 1 A short description of how to add a barcode to an Excel document and link the barcode with a cells content. Set floatRange = Worksheets("DEF_FLOAT").Range(floatStr) Set booleanRange = Worksheets("DEF_BOOLEAN").Range(boolStr) If Not Intersect(Target, Range("A:A")) Is Nothing ThenīRow = Worksheets("DEF_BOOLEAN").Cells(Rows.Count, 1).End(xlUp).RowįRow = Worksheets("DEF_FLOAT").Cells(Rows.Count, 1).End(xlUp).Row ![]() I have the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |