Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
option button disabled
Hi I have used the code below to try and disable the option button but get a debug error with the first line can you help Private Sub OptionButton9_Click() If Sheets("b28pricing!D11") 5000 Then OptionButton10.Enabled = False OptionButton10.Value = False OptionButton9.Value = True End If 5000 means in the cell (5000mm) but only the number is put in without the mm part Thanks -- raw ------------------------------------------------------------------------ raw's Profile: http://www.excelforum.com/member.php...o&userid=28312 View this thread: http://www.excelforum.com/showthread...hreadid=522294 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
option button disabled
If Sheets("b28pricing").Range("D11") 5000 Then
-- - K Dales "raw" wrote: Hi I have used the code below to try and disable the option button but get a debug error with the first line can you help Private Sub OptionButton9_Click() If Sheets("b28pricing!D11") 5000 Then OptionButton10.Enabled = False OptionButton10.Value = False OptionButton9.Value = True End If 5000 means in the cell (5000mm) but only the number is put in without the mm part Thanks -- raw ------------------------------------------------------------------------ raw's Profile: http://www.excelforum.com/member.php...o&userid=28312 View this thread: http://www.excelforum.com/showthread...hreadid=522294 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Cells option is disabled sometimes, how do I enable it? | Excel Discussion (Misc queries) | |||
paste option disabled after clicking copy | Excel Discussion (Misc queries) | |||
the merge cells option is disabled, i don't know why | Excel Discussion (Misc queries) | |||
Track Changes menu option disabled | Excel Discussion (Misc queries) | |||
Why is my sort menu option disabled? | Excel Discussion (Misc queries) |