Data from Listbox Column to Combobox

[gsandy]

I have a userform (frmClientInvoices) with a three column listbox (lstClientInv).
After making a row selection in the listbox I wish to pass the item in the third column of the listbox into a userform (frmInvoiceDetails) with combobox (cmbInvNo).
The frmInvoiceDetails is already open.
The command button code on frmClientInvoices I have so far is (but it’s not working):

Please Login or Register  to view this content.

How can I alter the code to get it working?
Thanks Sandy

[mehmetcik]

Please Login or Register  to view this content.

[gsandy]

Tried your code but got an error "Invalid or Unqualified reference" with ".ListCount" highlighted!!

[gsandy]

I have corrected a spelling mistake.

The first line of the code below works in that it puts the first column value of the list box into the combobox without any errors.
If I change it to the second line (without the first line) it does not work! It does not work with or without ".Value" at the end.

Please Login or Register  to view this content.

[torachan]

List columns are zero based & you need the index of your choice not the count.
torachan.
try

Please Login or Register  to view this content.

[gsandy]

I am still getting the same error message - "Invalid or Unqualified reference" with ".ListCount" highlighted.

[torachan]

why are you using .ListCount you need to know the index

[gsandy]

Attached is my current spreadsheet.
Click on the commandbutton to open frmInvoiceDetails.
Then click in "Client" textbox to open frmClientInvoices, and make a selection from the list.
Then click "Enter", which should put selection (offset by one) into combobox.
I.e. By selecting "Aaron Gordine" the value in compbobox should be "INV-0084".

[torachan]

Tools > References remove tick from the missing box.
Capture.JPG

[torachan]

Sorry, a little bit slow of the mark today - put it down to my advanced years - forgotten more than I have learned.
Working across two forms you have to be able to carry the variables - declare globals in a module - best to 'google' and do some reading.
I can not see why you are using two forms - make it easy on yourself - use a single form - declare your variables at the head of your code - start with "Option Explicit".
Then run debug as you develop each stage of your code to eliminate omissions.

[rorya]

To avoid the unqualified property call, use:

Please Login or Register  to view this content.

[gsandy]

Finally got it sorted by using the code below:

Please Login or Register  to view this content.

Thanks for all the input, it all helps in the understanding of VBA.
Cheers Sandy

[torachan]

alternative compact single form approach

[gsandy]

Thanks torachan. I was wondering how to develop a single form. I will now use your file to continue developing the project I'm on.
I loved your "advanced years" comment. I'm the same category!
Cheers Sandy