Hello
i have created a listbox with the active X option, the list box is getting a list of clients from a cell range, and when selecting any client from the list it triggers a macro that do different things depending on the client chosen. that works great.
The problem is that the last selecction always remains selected (in blue) and an additional click (if the next task is again for the same client) it is not possible unless you click somewhere else before clcicking same item again.
i have defined the last item of the client list as "-" and if clicking here, no macro is deployed, so nothing happens, now you can choose (make a click) again from any item on the list and execute the macro.
Is there any way to tell the macro when it is finished to move the blue ribbon (selection) to the last item in the list( "-")??? so i can skip clicking it manually after every time i choose a client from the list?
Thanks in advance
i have created a listbox with the active X option, the list box is getting a list of clients from a cell range, and when selecting any client from the list it triggers a macro that do different things depending on the client chosen. that works great.
The problem is that the last selecction always remains selected (in blue) and an additional click (if the next task is again for the same client) it is not possible unless you click somewhere else before clcicking same item again.
i have defined the last item of the client list as "-" and if clicking here, no macro is deployed, so nothing happens, now you can choose (make a click) again from any item on the list and execute the macro.
Is there any way to tell the macro when it is finished to move the blue ribbon (selection) to the last item in the list( "-")??? so i can skip clicking it manually after every time i choose a client from the list?
Thanks in advance