In the end I returned it and bought another VGA to USB adapter. There were no holes to screw the VGA cable into the adapter so the fit was not secure.
Cable Baseus Cafule USB - Lightning, 1 m, black/red
26 Review
Ultimate Compatibility: USB C to HDMI Adapter for MacBook, iPad, Dell, Surface & More
12 Review
Cable Matters USB C to HDMI Adapter - 4K 60Hz, 60W Charging, Thunderbolt 4 Compatible for MacBook Pro, iPad Pro
12 Review
π΄ 2 Pack JSAUX HDMI Coupler Female to Female for 4K HDR Extension - Aluminum Alloy Adapter for HDTV, Roku Stick, Computer, Monitor, Laptop, Projector, DVD Player, PS 4/3 (Red)
12 Review