Limiting the Listbox on Userform on Input data of another Listbox

[Pramod KLN]

Hello Every one!

I have two Work Sheets Parties and Sales. Two Userforms "formPartyentry" and "formSalesentry"
In "formsalesentry" I have two Listboxes one for Party Name Selection, which is a multicolumn listbox, which displays Partyname, GST No, and State. The other Listbox displays two items "Local" and "Interstate"

Now what I want is If I Select any party having his state as "Telangana" in the First list box The other Listbox should display only local and if the State is "<> Telangana" it should display "Interstate" only. This I am asking only to avoid user selecting wrong option for "Local" and "Interstate"

Is it Possible ?

Further If the Party Name is not there in the first List box it should ask the user whether he wants to add new party if the answer is yes, it should open "formpartyentry" to take the data and come back to the "formsalesentry" to complete the Sales Entry.

Right now I am closing the "formsalesentry" opening "formpartyentry" finish the party entry- close the form and open "formsalesentry" and continue the sales entry.

Thanks in advance.