ListBox Double Click () selection from another worksheet and populate data in text box

[imzhakmaya]

Hi,

I have been trying to search for the correct codes in my List Box double Click () for the userform that I have interfaced but to no avail.

Would appreciate if some one can help me with the following:

1) List Box to select item code from Database worksheet
2) Msgbox to indicate the item code number when selected
3) Textboxes and option button to populate from list box selection

Please Login or Register  to view this content.

Also, when I double click the output doesn't select the data instead displaying the labels

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[imzhakmaya]

I appreciate it Alan, will comply with the rules in future threads...

Thanks a lot!!

Imzhakmaya

[imzhakmaya]

Hi,

I've attached my workbook for easy understanding... the interface is not ready yet as I've just coded for Add Item, Modify Item only....


Need help on this, thanks a lot!!!


Imzhakmaya

[mike7952]

here's a start

Please Login or Register  to view this content.

[imzhakmaya]

Hi Mike,

Thanks a million...


Imzhakmaya

[AlphaFrog]

Another method is to use the ListIndex offset to the row number. They appear to be offset by two.

iRow = Me.ListBox1.ListIndex + 2