I have developed a costing model for our products. It includes a radio button that you can select if the product is put on a skid or not. This triggers several calculations that affect time to produce the product and other things as well. Due to the length of some of our products we cannot skid anything longer than 144". I was wondering if there is a way to lock the radio button in the "No Skid" position if the entered length of the product is greater than 144".
Yes. Where does the user enter the length? On a worksheet, or on a userform? Where is the radio button located? Is it a Forms radio button or an ActiveX radio button?
I have worked with ActiveX radio buttons and have more limited experience with Forms controls, so I'll describe what you would do with ActiveX controls.
If this is on a worksheet you would use Worksheet_Change to capture changes on the sheet. If length is entered, and it is over 144, then the code would set the radio button value to False and then set the Enabled attribute of the radio button to False. If the length is <=144 then you would set the Enabled attribute to True.
As always, if you attach your file we can give you a more specific solution.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
The length and radio buttons are both on the same worksheet. The radio buttons were created from the commands in the Developer tab so I don't believe they are ActiveX. Also, below 144" I want the ability to select skidded or not skidded.
Another option would be to use a drop down list instead of the radio (option) buttons.
I assume the option buttons include "Skid" and "No Skid".
You could use a drop down list based on the length value. If the length is <=144 then the drop down list would have both selections available. If the length is >144 then the only selection would be "No Skid".
OTOH, option buttons look better!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
The Developer tab for worksheets has both Forms and ActiveX controls available.Originally Posted by dblcrona
If you attach your file I (or someone) can just do the fix for you, though if it's a costing model be sure to remove any proprietary data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks