Link to home
Create AccountLog in
Avatar of tjd71
tjd71

asked on

Set the value selected for an ActiveX ComboBox using VBA

I am trying to set the value selected for an ActiveX Control Box using VBA to the first item in the list or blank. When recording the macro no code is produced for the action.
ASKER CERTIFIED SOLUTION
Avatar of [ fanpages ]
[ fanpages ]

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of tjd71
tjd71

ASKER

Thanks FP, I am away from the office until Thursday and will try it then.
OK.  Thanks for letting me know.
Avatar of tjd71

ASKER

Hi Fp,

Thanks :) Too easy once you know how.

Cheers
tjd71
:) You're welcome.

Sometimes it is the simplest of things that become the most difficult to discover!

Good luck with the rest of your project.