Replies

Hans,

Thank you very much for your help. I now have it sorted out. It works without code!

Here’s what I have found out using the line:

Private Sub Calendar1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer

a Compile error appears:

Procedure declaration does not match description of event or procedure having the same name

I think I realise that means I have the routine in the wrong place.

Hans,

Yes you are right that I should try it. But as my efforts to get a handle on VB over several years have been a dismal failure I am seeking the comfort of further guidance. After all I could `break’ what has already been achieved.

On the other hand, in a nice way, you may be telling me it will work! {8;-))

Many thanks for your help with this. It is very difficult to teach an old dog new tricks so I am pleased to be able to tell you that I have been able to enter your code & with a few stumbles get it to work OK for both combo boxes.

Can I assume that the same code, suitably modified, work with Calendar Control 9.0 also from the Control Toolbox?

Thank you for your reply. I am delighted by the responses to my question.

As it is 01:10 here in UK I will take this up again in the morning.

Thank you for your quick & helpful reply & the information therein. I’ll look into what you have told me.

I’ll take a look – thank you.

As it happens that check box is greyed out & clear.

Is this a misunderstanding or did I get it the wrong way round? I meant `cheque’ shows as an error for `check’ because the checking defaults to English US when I have it set to English UK. I have one document where the spell check changes from UK to US & back again!

I have wondered if the problem started with me taking over a set of Word files from my predecessor as honorary secretary of a social group.

Thanks – I’ll take a look.

Thank you for your comments & suggestions. For the amount of messaging (40 messages maybe twice or three times a month) I need to do with a merge it hardly seems worth going to so much trouble. Other than being retired I could treat as a challenge; worth doing for the sake of it!

If I change the setting from US to UK while spell checking the change reverts to US when the next spelling `error’ is reached. For example `cheque’ & `check’.

I assume the macro could be created with the Record Macro Tool & I will try this approach.

Thank you for your helpful response.

I had already done what you suggest & deleted the English US option there.