Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Anthony - Combo box on User Form
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Anthony - Combo box on User Form
Resolved · High Priority · Version 2003
Reply Sun 27 Nov 2011, 21:33Delegate Sharon said...
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.
For upcoming training course dates see: Pricing & availability
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
Tue 6 Dec 2011: Automatically marked as resolved.
|