I am working with a project that has a series of workbooks to collect data from our various machine operators. They fill out a row of data, including a combobox for listing any problems during a particular hour. If there are multiple problems, they can click a checkbox and add an additional row. This adds a new combobox to the new row, but I can't seem to figure out how to make it a comboboxlist, type 2, which limits entries to the list in the drop-down. With these newly generated comboboxes, the user can enter anything, and we don't want that. In the existing comboboxes, I simply set the style property to 2 - comboboxlist, but I can't figure out how to apply that to the code.
This is the code I have for the new comboboxes:
Any help would be appreciated!PHP Code:
'To add combobox for problems
Set x = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1")
x.Name = cmboxName1
x.Height = Rows(rowOffset).Height
x.Width = Columns("G").Width
x.Left = Columns("G").Left
x.Top = Rows(rowOffset).Top
x.Object.Font.Size = 10
Bookmarks