As a user I prefer to be presented with valid choices only, rather that be
allowed to pick an invalid choice and then be told it wasn't right. If it
was wrong why did you give me that choice? (I ask). So, in your situation,
I'd use the option buttons' Enabled property to turn off invalid choices
before the user even sees the userform.

--
Jim Rech
Excel MVP
"ewan7279" wrote in message
...
| Hi,
|
| I have created macros to update cost centre spreadsheets from a range of
| data. The macros run from a form that has 12 options (1 for each month)
and
| I want to display a warning message to the user to ensure that they have
| selected the correct month.
|
| The macros currently enter the number relating to the month chosen into a
| cell on one of the sheets. I have used the validation option to give a
| warning for any entry put into the cell, but data entered by macros does
not
| cause the warning to display.
|
| Can anyone offer a solution to this problem please?
|
| Thanks,
|
| Ewan.