Recent content by Jimmy the Hand

Let's assume this is the event procedure of Button1 Private Sub Button1_Click() 'code line 1 'code line 2 'code line 3 End Sub You can break it into two like this 'This goes to a standard module Sub Button1_Click_Core() 'code line 1 'code line 2 'code line 3 End sub 'This...

Event procedures don't start with F5 or F8. They are called on by the corresponding events. However, you can put breakpoints into the event procedures, too. Breakpoints will stop code execution, and then you can use F8 to step by step debugging. But you still have to click on the button, or...

Hi, I can't say I understood your last post with the explanation, despite I think I can contribute to your success. What Bob said about event order is true, still I think the OnClick event will be perfect here, because changing the value of the checkbox via VBA code doesn't fire another...

Hi, I guess you want this to be OnClick event of the checkbox. Event handlers are usually subroutines. Is there a reason here, why you use a function instead? If it was my project, I would use something like this code: Sub isGroupedOnClick() Dim Msg as String, Title as String Dim...

Hi I'm not sure why you want to use function, but here's something that works. These are subroutines that do and undo the highlighting. Note that form and control names are input parameters. Sub Highlight(ByVal frm, ctrl As String) Dim HighlightColour As Long HighlightColour = RGB(255...

Aelyn, you need to convert those row indices into strings. Try this Rows(Cstr(saurus) & ":" & Cstr(Skink)).Select

Do you insist on using "ActiveWindow.ScrollColumn = 8"? Maybe "ActiveCell.Show" will do?