Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Follow up from Bob Phillips' Answer on Programatically Making Chec
Hi Everyone.
Previous Thread - On Change (Checkboxes) or something similar Bob was thoughtful enough to provide me with a solution to my problem with checkboxes...However, today I began to experience another problem all-together. A section of my code is shown below: With ActiveSheet .CheckBoxes.Add(.Range(CellRef).Left, Range(CellRef).Top - 1.5, 0, 12.75).Select Selection.OnAction = "SpreadBoxes" Selection.Caption = "" Selection.LinkedCell = CellRef End With The weird thing is that this code worked fine yesterday, but then today when I tried to use it again the Selection.OnAction ="SpreadBoxes"; Selection.Capiton and Selection.LinkedCell ALL return the error "Object doesn't support this property or method." What could cause such an error? Can anyone provide any guidance? I actually rewrote the whole subroutine this morning to try and figure it out, but had no luck to speak of. Thanks in advance for any help, and thanks again to Bob for his help yesterday. David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Follow up from Bob Phillips' Answer on Programatically Making Chec
Amazing...I spent a few hours on this already today, but only just realized
what the problem is. That is: it was my worksheet changed handler that was causing the problem. If I disable it, everything works perfectly. Sorry to waste your time if you read the previous message, but I guess writing down the problem made me think it HAD to be something specific to the workbook. This newsgroup is great, you all are so very helpful. David "David" wrote: Hi Everyone. Previous Thread - On Change (Checkboxes) or something similar Bob was thoughtful enough to provide me with a solution to my problem with checkboxes...However, today I began to experience another problem all-together. A section of my code is shown below: With ActiveSheet .CheckBoxes.Add(.Range(CellRef).Left, Range(CellRef).Top - 1.5, 0, 12.75).Select Selection.OnAction = "SpreadBoxes" Selection.Caption = "" Selection.LinkedCell = CellRef End With The weird thing is that this code worked fine yesterday, but then today when I tried to use it again the Selection.OnAction ="SpreadBoxes"; Selection.Capiton and Selection.LinkedCell ALL return the error "Object doesn't support this property or method." What could cause such an error? Can anyone provide any guidance? I actually rewrote the whole subroutine this morning to try and figure it out, but had no luck to speak of. Thanks in advance for any help, and thanks again to Bob for his help yesterday. David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Follow up from Bob Phillips' Answer on Programatically Making Chec
David,
What does the change handler do? -- HTH Bob Phillips "David" wrote in message ... Amazing...I spent a few hours on this already today, but only just realized what the problem is. That is: it was my worksheet changed handler that was causing the problem. If I disable it, everything works perfectly. Sorry to waste your time if you read the previous message, but I guess writing down the problem made me think it HAD to be something specific to the workbook. This newsgroup is great, you all are so very helpful. David "David" wrote: Hi Everyone. Previous Thread - On Change (Checkboxes) or something similar Bob was thoughtful enough to provide me with a solution to my problem with checkboxes...However, today I began to experience another problem all-together. A section of my code is shown below: With ActiveSheet .CheckBoxes.Add(.Range(CellRef).Left, Range(CellRef).Top - 1.5, 0, 12.75).Select Selection.OnAction = "SpreadBoxes" Selection.Caption = "" Selection.LinkedCell = CellRef End With The weird thing is that this code worked fine yesterday, but then today when I tried to use it again the Selection.OnAction ="SpreadBoxes"; Selection.Capiton and Selection.LinkedCell ALL return the error "Object doesn't support this property or method." What could cause such an error? Can anyone provide any guidance? I actually rewrote the whole subroutine this morning to try and figure it out, but had no luck to speak of. Thanks in advance for any help, and thanks again to Bob for his help yesterday. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
Creating fillalbe check boxes in excel by double clicking on chec. | Excel Discussion (Misc queries) | |||
making a cell go red when answer in questionnaire is wrong | Excel Discussion (Misc queries) | |||
Convert $12.00 to text (Twelve dollars) like you would on a chec.. | Excel Worksheet Functions | |||
Bob Phillips | Excel Programming |