How to Use Select state with vba listbox

Mohammad Ishaq 21 Reputation points
2020-08-05T18:57:54.893+00:00

I have a userform with a list box and some controls on it.I have write a code with in the list box in such a way that when i click any item of the listbox,the caption change according to the selection of listbox.For this purpose i have used "Select Case".But the code is working for the first two items and after that the code is not working for other items.Please help me to correct my code.The file is in attachment in link.

https://1drv.ms/x/s!AvZAiO-9qIzOiB7XU3qbbF9K89wH?e=89L0Xm

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
42,143 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2020-08-05T22:24:33.603+00:00

    Excel development is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
    https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.