Forum Discussion
carllarner45gmail
Jan 14, 2023Copper Contributor
Combo Box
Hi There I have a 2 column combo box, see example below 5 BI 6 S 7 PA 8 P 9 O The 2 columns will show in the combo box and my selection will return the numeric valu...
HansVogelaar
Jan 14, 2023MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- carllarner45gmailJan 15, 2023Copper ContributorGood evening Hans
Thank you for your response to my Colour Font in Combo Box query and my apologies for the late reply.
I have been re-assessing the feasibility of the combo box solution to my problem and with the shear number of combo boxes required to resolve my problem with this option i have got to find another solution.
Its a by day monthly diary I'm constructing and with 365 days in the year per person, with up to 8 persons it makes it unfeasible to add that many combo boxes to a worksheet.
I've exterminated with just simply typing the the data to each cell daily and using the change Font colour off the toolbar, this naturally works but is a time consuming operation, what I need to investigate is how to build/put a custom font colour palette directly onto my worksheet with just the 5 colours I require.
Once again thank you for your time in replying and my apologies if I've wasted your time.
Kind regards
Carl