poleary2000
Active Member
- Joined
- Apr 1, 2002
- Messages
- 354
I have some code that runs when the user double clicks. Upon that double click, a list box is displayed with three columns. I want the user to select a row and press OK. Upon pressing OK, I want the value from Column 1 to be populated into the target cell that was originally double clicked on.
I have everything working except for the getting the value selected and then placing into target.
I've used code like this before to figure out what the user selected:
For n = 0 To (CountListArray - 1)
If ExpenseErrorsListBox.Selected = True Then
ItemSelected = ExpenseErrorsListBox.List(n, 1)
End If
Next n
How would I then, but that value into a cell?
I need some guidance.
I have everything working except for the getting the value selected and then placing into target.
I've used code like this before to figure out what the user selected:
For n = 0 To (CountListArray - 1)
If ExpenseErrorsListBox.Selected = True Then
ItemSelected = ExpenseErrorsListBox.List(n, 1)
End If
Next n
How would I then, but that value into a cell?
I need some guidance.