Hello,
I have a sheet "Clients" that contains all clients details as the table below and I have all these data as dynamic named range "Client_Details" "A2:D4"
I have a userform with many text boxes and combo boxes, but what I need right now is:
<tbody>
</tbody>
Many thanks in advanced
I have a sheet "Clients" that contains all clients details as the table below and I have all these data as dynamic named range "Client_Details" "A2:D4"
I have a userform with many text boxes and combo boxes, but what I need right now is:
- Once I choose a Client name in the combobox1, get the ID for this client on textbox1 and the phone number on textbox2
- ex: if I typed "Nael" from the combobox1, get the ID "102" on textbox1 and the phone number "654654" on textbox2
- If I typed a name that not exist, get msgbox ("This Client Name is not Exist" & vbCrLf & vbCrLf & "Do you wanna add a new client?" , vbYesNo)
- If vbYes then, open the userform "NewClient" (And add a new client and then update the list on combobox1 to get the new client)
- If vbNo, combobox1 = ""
A | B | C | D | |
1 | ID | Name | Phone | |
2 | 101 | Nadim | 123456 | sadas |
3 | 102 | Nael | 654654 | asdasd |
4 | 103 | Rami | 545645 | asfdaf |
<tbody>
</tbody>
Many thanks in advanced