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 |
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 |
All times are GMT +1. The time now is 08:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com