force

I have two groups of checkboxes (1-7 and 8-11). I am in need of vba code that will force the user to choose at least one checkbox in the group of 1-7. The checkboxes are in a merged cell range A9:K10. Additionally, if checkbox 7 is selected then L9:O10 must be filled in. Checkboxes were...

Hey I have found some code on VBA Express which I really like. It is the smoothest running code to perform is task that I have come across, however I have a small problem that is annyoning me. For orignal post: http://www.vbaexpress.com/kb/getarticle.php?kb_id=578 If I close the the...

Hi team, I have posted this same query at http://www.excelforum.com/excel-programming/780925-forcing-input-by-user-when-cells-are-changed.html#post2548789 a few days ago, but unfortunately there have been no replies. I am ultimately trying to achieve a track changes with commentary by the...

Excel 2007 - I currently have a sheet "Main" that contains many buttons for selecting reports, data entry userforms, etc. When the user selects one of these buttons the appropriate worksheet is unhidden and becomes the active worksheet. Each worksheet contains an "Exit" button with a macro to...

Is it possible to force a relative reference for the following: =INDIRECT("a"&1) I understand that this is an odd thing to try to do. What I'm trying to accomplish is too complicated for me to attempt to explain. Here is one of the formulas that I'm trying to force to be a relative...

I currently have a database set up with one sheet named "Master" the Master sheet has all of my ranges, labels, headers, and format set how I would like all sheets within the workbook to be set. I would like to make this workbook "foolproof" seeing as how some of the people who may be using it...

Is it possible to force users to make a valid entry in three different cells before a button with an assigned macro is visible or clickable? For example, I want them to complete cells A5, B5 & C5. The first is a dept. code which can only be numeric (01 - 08). The second is the month (01 - 12)...

I am putting together a simple feedback survey. I have a list of questions/statements that the user has to score from 1-5. (example: Rate the level of customer service you recieved). I have used option buttons to represent the numbers 1-5 and these are linked to cells in a hidden sheet and are...