MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
Hello! how can i code to have the value from userform1. listbox index (0) referenced and found in the active worksheet ("Customers") column "A" and then have column values from that row on the worksheet populate into textboxes when userform2 initializes? The listbox is on single select....
on userform1. listbox is filled with several customers and multiple columns. Column 1 holds the ID number which is the reference to find in worksheet("Customers").
So with this customer highlighted on userform1 I will click a command button "Insert Order" also on userform1 in which USERFORM2 will open, the click also activates worksheet ("Customers") and I would also like for this click to execute the code to find the selected listbox index value on the active worksheet and to pull the column values from that row to userform2....
textbox14 = worksheet "A".value
textbox15 =worksheet "B".value
textbox16 = worksheet "C".value
textbox17 = worksheet "D".value
textbox18 =worksheet "E".value
textbox19 =worksheet "F".value
Any help with showing how to code this will be greatly appreciated!!!