Making A Listbox Select A Cell.

[abxy]

hi,

i'm working on a userform. it has a listbox. when the form starts up, it looks in column A for any cells that have something in it (starting after row 2).

for each cell that has something in it, a line is added to the listbox. the line added in the listbox is whatever the value of the cell and the cell one column right of it was.

here's the code:

Please Login or Register  to view this content.

now, i'm trying work on code that will make it so that when i click on a line in the listbox, the corresponding cell in row A will be selected. but i don't know how to do this. any ideas?

thankyou

[bhofsetz]

Add this click event code to your userform

Please Login or Register  to view this content.

Right now it only works correctly on contiguous data in A but I'm working on getting it to recognize skipped cells to deal with non contiguous data.

Hope this helps

[bhofsetz]

OK, I figured out a better way which ignores blank entries in column A
use this in the listbox click event rather than the code I posted earlier

Please Login or Register  to view this content.

Hope this helps

[mister190]

hey i'm looking for the same... but i want to select multiple cells with the option multiselect...

can you help me???

[marc5354]

mister190

Read forum rules before you post a comment, Start a new post for your query.

Marc