Search results

Worked like a charm. You are a star. Thank you!

Thanks for the help. I will try to implement what you have suggested and will report back with my results. It does seem likely that i came across your code then. Either directly or second hand from someone else who benefited from your wisdom.

Hi MajP Sadly the code was not adapted from your previous code. What you have demonstrated in your posts above is exactly what I want to do. However, I am unclear where I would insert the code you have written into my existing code to make it happen.

Thanks but I have already tried conditional formatting. I am not sure if it because of the way the LoadArray works but putting conditional formatting on the textbox does not work. The issue as well is I need to be able to have multiple different text colours in the same textbox where there are...

Now that I have gotten rid of the superfluous code I have a follow up question. I would like the font colour to change depending on the City. I have tried using [City].ForeColor but must be doing something wrong. For example, if the exam is in London the word ‘London’ on the Calendar array...

JHB - thank you. That worked perfectly. Seems so simple now but I just couldn’t see it myself.

Hello. Brand new member. First time posting, although I have taken many useful hints and tips from the forum in the past before joining. I am now asking (begging) for some help. I have a form, which contains 42 textboxes to create a calendar layout. The code works fine for displaying the...