The question whether or not a closed universe will collapse depends on the roots of the Friedmann equations. For $\Lambda$CDM models, these are
$$\begin{align}
\dot{a}^2 &= H_0^2\left(\Omega_{M,0}\,a^{-1} + \Omega_{K,0} + \Omega_{\Lambda,0}\, a^2\right),\tag{1}\\
\ddot{a} &= H_0^2\left(-\frac{1}{2}\Omega_{M,0}\,a^{-2} + \Omega_{\Lambda,0}\, a\right),\tag{2}
\end{align}
$$
where $\Omega_{M,0}$ and $\Omega_{\Lambda,0}$ are the present-day matter and dark energy parameters, we ignore the (small) contribution of radiation, and $\Omega_{K,0} = 1 - \Omega_{M,0} - \Omega_{\Lambda,0}$. We can rewrite $(1)$ as
$$
f(a) = \frac{a\dot{a}^2}{H_0^2} = \Omega_{M,0} + \Omega_{K,0}\, a + \Omega_{\Lambda,0}\, a^3,\tag{3}
$$
along with its derivative in $a$
$$
f'(a) = \Omega_{K,0} + 3\,\Omega_{\Lambda,0}\, a^2.\tag{4}
$$
Consider the following example:
This plot shows $f(a)$ for three models with $\Omega_{M,0}=2.5$. The green model, with $\Omega_{\Lambda,0} = 0.15$, expands forever. The blue model, with $\Omega_{\Lambda,0} = 0.05$, has a root at $a_0 = 1.8015$. Since $\ddot{a}<0$ at this root, $\dot{a}$ changes from positive to negative, so this model will collapse. The red model is a boundary case: here, both $\dot{a}$ and $\ddot{a}$ are zero at the same point, $a_0 = 2.3490$, so the expansion comes to a temporary halt, but then continues. To find these boundary models, we need to obtain an expression for $\Omega_{\Lambda,0}$ for a given value $\Omega_{M,0}$, such that
$$
f(a_0) = f'(a_0) = 0,
$$
where $a_0 > 1$. Instead of solving for $\Omega_{\Lambda,0}$ directly, we will solve for $\Omega_{K,0}$ first. By plugging
$$
f'(a_0) = \Omega_{K,0} + 3\,\Omega_{\Lambda,0}\, a_0^2 = 0
$$
into $f(a_0) = 0$, we can eliminate $\Omega_{\Lambda,0}$ and obtain
$$
3\,\Omega_{M,0} + 2\,\Omega_{K,0}\,a_0 = 0.\tag{5}
$$
We plug this back into $f'(a_0) = 0$ to eliminate $a_0$:
$$
4\,\Omega_{K,0}^3 + 12\,\Omega_{\Lambda,0}\,\Omega_{K,0}^2\, a_0^2
= 4\,\Omega_{K,0}^3 + 27(1 - \Omega_{K,0} - \Omega_{M,0})\,\Omega_{M,0}^2 = 0,
$$
or
$$
\Omega_{K,0}^3 - \frac{27}{4}\,\Omega_{M,0}^2\,\Omega_{K,0} +
\frac{27}{4}(1 - \Omega_{M,0})\,\Omega_{M,0}^2 = 0.
$$
This is a cubic equation in $\Omega_{K,0}$ of Cardano form $t^3 + pt + q = 0$. Its three roots are
$$
\Omega_{K,0}^{(k)}
= -\frac{3}{2}\Omega_{M,0}^{2/3}\left[e^{4\pi ik/3}
\left((1 - \Omega_{M,0}) + \sqrt{1 - 2\,\Omega_{M,0}}\right)^{1/3} +\right. \\
\left. e^{-4\pi ik/3}
\left((1 - \Omega_{M,0}) - \sqrt{1 - 2\,\Omega_{M,0}}\right)^{1/3}\right],
$$
with $k=0,1,2$. If $\Omega_{M,0}\geqslant 1/2$, these three roots are real, and we can write
$$
(1 - \Omega_{M,0}) + \sqrt{1 - 2\,\Omega_{M,0}} = (1 - \Omega_{M,0}) + i\sqrt{2\,\Omega_{M,0}-1} = re^{i\theta},
$$
with
$$\begin{align}
r &= \sqrt{(1 - \Omega_{M,0})^2 + 2\,\Omega_{M,0}-1} = \Omega_{M,0},\\
\theta &= \arccos\left(\frac{1 - \Omega_{M,0}}{\Omega_{M,0}}\right),
\end{align}
$$
so that
$$
\Omega_{K,0}^{(k)} = -3\,\Omega_{M,0}\cos\left(\frac{\theta + 4\pi k}{3}\right).
$$
If $\Omega_{M,0}\geqslant 1$, the $k=1$ root defines the collapse boundary. Indeed, $\pi/2\leqslant\theta < \pi$, so that
$-3/2\,\Omega_{M,0} < \Omega_{K,0}^{(1)} \leqslant 0,$ and from $(5)$ we get $a_0 > 1$. One can further verify that the $k=2$ root is unphysical ($a_0 < 0$), while the $k=0$ root defines the boundary of models with no Big Bang ($a_0 < 1$).
Therefore,
$$
\begin{align}
\Omega_{\Lambda,0}^{(\text{collapse})}
&= 1 + \Omega_{M,0}\left[
3\cos\left(\frac{\theta + 4\pi }{3}\right) - 1\right] = 4\,\Omega_{M,0}\cos^3\left(\frac{\theta + 4\pi}{3}\right),
\end{align}
$$
where we used the identity $3\cos x = 4\cos^3 x - \cos 3x$. The plot below shows this boundary, between the red and the yellow area. The red dot corresponds with the red model in the first plot. Note that the $\Lambda$CDM model corresponding with our universe (black dot) will not collapse.