Hey vbajock,
I'm not familiar with a datagrid object. Can you give me a quick summary? There's nothing in the help files with that name.
Thanks!
-dmreda
Thanks for all the responses! VBAJedi's idea of several listboxes adjacent seems the quickest to implement, so I'm going with that. It's just a look-and-feel prototype I've got to deliver with a project proposal, but the mouse position idea is very clever, and I may wind up using something like...
Hi,
If I create a multi-column list box, and the user clicks on it anywhere, I can get what ROW they clicked on easily enough (using the ListIndex attribute).
However, how can I determine which COLUMN the user clicked in?
Is there an object better suited to this than a listbox?
Thanks,
-dmreda
Hi,
If I create a list box, and the user clicks on it anywhere, I can get what ROW they clicked on easily enough (using the ListIndex attribute).
However, how can I determine which COLUMN the user clicked in?
Is there an object better suited to this than a listbox?
Thanks,
-dmr
Hi,
I think you need to use "additem" to put the very first item into a row, and then you can use "list" to populate other columns.
Example:
cboMyCombo.additem "in the first row"
cboMyCombo.list(0,1) = "in the first row and second column"
The numbering system runs from 0 to NumColumns-1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.