![]() Excel Barcode image Add barcode images to Excel workbooks using the ActiveBarcode Generator. unfortunately the following lines don't work: cb. Excel Barcode object Embed and automate the barcode control in an Excel sheet. ![]() 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. 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 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |