Sharon has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Anthony - Combo box on User Form
Hello,
I have created a user form which uses combo boxes to determine which record is to be updated and then data is inputted for that record in to my data sheet in Excel.
I'm not sure if it's possible but is there a way to format the combo box so that if information has been entered in for a particular record, it highlights that name or puts a tick against it (for example) so that you can see which records have been updated and which are yet to be updated?
Any help would be appreciated!
Thank you.
RE: Anthony - Combo box on User Form
Hello Sharon,
Unfortunately, what you require is not possible at the combo box level, although not impossible to achieve, but requires deeper programming using Class Modules, and creating your own class object. Unfortunately, i'm unable to explain the whole programming required here.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
