B
BJ
I'm wondering how to control cell entry [data entry generically] based on an
option control.
I have two option buttons. Option Button 1 should allow data entry into
cell A1 for example and Option Button 2 should allow data entry into cells
A3:A7. However, when Option Button 1 is selected I want to disable entry for
cells A3:A7 and when Option Button 2 is selected I want to disable entry for
cell A1.
I'm open to using some sort of control [please explain as I am a VBA rookie]
instead of the spreadsheet cell if that's the only way to make this work.
I've done this with Option Buttons controlling Check Boxes, but I'm not sure
how to control data entry.
Thank you.
B
option control.
I have two option buttons. Option Button 1 should allow data entry into
cell A1 for example and Option Button 2 should allow data entry into cells
A3:A7. However, when Option Button 1 is selected I want to disable entry for
cells A3:A7 and when Option Button 2 is selected I want to disable entry for
cell A1.
I'm open to using some sort of control [please explain as I am a VBA rookie]
instead of the spreadsheet cell if that's the only way to make this work.
I've done this with Option Buttons controlling Check Boxes, but I'm not sure
how to control data entry.
Thank you.
B