Hi folks

As a relative newbie to VBA, with any queries I have I try a web search, forum search and then I post! I am pretty sure my issue is not unique and I am pretty sure there will be another post alredy listed... I never quite know the right phrase to enter in the search tools to find what I am looking for!

So, after many searches which result in me going nowhere fast, I apologise for the request in advance!

I have some data validation lists to control data quality in my spreadsheet. As with most users, in order to select a response I must firstly click in to the cell, which in turn displays the dropdown handle, then click the handle and finally make a selection from the list displayed.

Please can you assist me with - How can I achieve an automatic display of the dropdown as soon as I click in to the relevant cell, using VBA?

Will the code be cell specific or can it be a more holistic code, which I would imagine slows down the performance?

I hope the fact that I am a Office for Mac user (Office 365 v16.15) does not further complicate matters... most of the users of my creation will be PC users

Thank you in advance