![]() ![]() 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. 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) About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright. 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 Then, select the barcode control from the list of available ActiveX Controls After selecting it, click and drag an area for the control to appear in the spreadsheet. Now go to the menu 'Insert' and select the 'Object.' menu item. The only difference between these machines is that the ones that do not show the barcode, is missing the activex control in access. Start the Excel and create a new sheet or open an already existing sheet. I have the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) We have an application written in Access that places a barcode onto our labels, but we are finding that certain machines will place the barcode where it should be, and others that will not. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |