lemon_balm
Registered User.
- Local time
- Today, 00:54
- Joined
- Feb 7, 2006
- Messages
- 65
Hi all
I need to create a piece of VBA to stop data being entered into a particular cell unless certain other ones are blank. THis is is ensure that no data is entered for an overall category if anything has been entered for it's subcode.
I.e. If cells E4 to E7 contain data then cell E3 cannot be filled in. Preferably I would like to have a message box pop up to state this and then the focus return to the first line of subcodes (E4)
Does anyone have any ideas as I cannot get my head around msgboxes within excel or connecting If statements for that matter.
Oh, by the way, I am using Excel 97
Regards
Jason
I need to create a piece of VBA to stop data being entered into a particular cell unless certain other ones are blank. THis is is ensure that no data is entered for an overall category if anything has been entered for it's subcode.
I.e. If cells E4 to E7 contain data then cell E3 cannot be filled in. Preferably I would like to have a message box pop up to state this and then the focus return to the first line of subcodes (E4)
Does anyone have any ideas as I cannot get my head around msgboxes within excel or connecting If statements for that matter.
Oh, by the way, I am using Excel 97
Regards
Jason
