Form Checkbox. Having Issue With Going From Different Cell Typed In To Form Checkbox

[aedctalk]

HI. I have an annoying issue i was wondering if there is any solution for?

My page is filled in with cells that require an answer typed. followed by form checkboxes.

However When i type something.. and there is the blinking cursor in the cell.. and then i go to check the form checkbox it wont let me check it. First i have to click out of the cell i was in somewhere else... and then i'm able to click teh form checkbox..

Is there anything i can do to be able to go from that cell i'm in and then directly click the form checkbox?

Seems like something that would change the formcheckbox to active or maybe the cell i was typing in from being the "active" cell woudl work?

Just dont know how to besst make that happen?

Just an annoying pet peeve of many fellow employees where i work.. that i'd love to fix?

Thanks ! :D

 

[Andrew Poulsom]

I can reproduce that behaviour with a CheckBox from the Control Toolbox. Try one from the Forms Toolbar.

 

[aedctalk]

well all my checkboxes are made from form toolbar and that is the behavior i'm getting


if you type in a1 and then have a form checkbox and try to click it whiel cursor still blinking in a1 then you can't click the box ...

just trying to remove that. so you dont have to click out first then click checbox.

i'd hate to have to switch them all to boxes made with control toobox. since there are so many of them i have.. (like 40 or so)


here's code associate with the checkbox if that'd make any difference

Sheets("ManagerLog").UnProtect
Dim cb As Excel.CheckBox

Set cb = Excel.ActiveSheet.CheckBoxes(Application.Caller)
If cb.Value = xlOn Then
Rows("64:65").EntireRow.Hidden = False
Else
Rows("64:65").EntireRow.Hidden = True
End If
Sheets("ManagerLog").Protect

 

[aedctalk]

ohh ok. so i guess it has something to do with my code that i posted for the "yes" checkbox above.. because ..

i also have a no checkbox with no associated code.. (form toolbox made too..) and that one does not have the same behavior..


what in my code above could be causing this do you think?

anyway to fix?

 

[Andrew Poulsom]

I expect it's because you can't run a macro while Excel is in Edit mode. Sorry, I don't know a solution.

 

[aedctalk]

thank you alot! that makes sense.

not working because i'm in edit mode. and then trying to run the macro while its editing the value of the cell.....

thats shame though. no fix oh well! :D