I created a list box from within the vba code when I selected some combo box items, in fact when selecting the combo box item , A SQL is run on a database table and the resulting archive set is fed into an array, which later fills a multi-dimensional listbox.
It appears within the UserFed modules but I have added a click and a double click event for the list box, but neither work.
The following code is used to create a list box within the user module.
Dim control as lst.CleumnCount with lst = me.Controls.Add ("Forms.Listbox.1", "lstOutputList") line = UBound (output list, 2) = X = 0 column for column - 1 for y = 0 rows. If the item is not out (output list (X, Y)) Then list (y, x) = output list (x, y) other List (y, x) = = "for the end if the next y = next to the next count. ListContact + 1 Step-1 for rows. Revight numbers - 1 next count. Boundcollege = 2. Multi Select = FM Multi Select Singal. Left = 270 .Pept = 100 .Width = column * 70 if rows & gt; 50 then = 300 others Heat = Rows * Ends with end and end
, lists are created and look fine on the form, these are just events that do not firing I have tried both lst_click () and lstOutputList_Click () events and equivalent double click events, nothing does not work
No comments:
Post a Comment