The reason we only ran it for a week is that we really want to try and get this server ready before the holidays, where many in the community finally have some days off and time to sink themselves in to some SWG fun. We have about 2500 unique accounts that log into Basilisk each month, so by running the survey longer, we would have a larger sample size to draw upon.
Features planned to be in publish 11 can be seen in the SWGEmu Roadmaps Our current focus is the Publish 11 Checklist. A helpful guide to bug reporting can be found here. You can still report all bugs you find on Test Center Nova to the Mantis Bug Tracker. You can find all commits to Test Center Nova here. If Mid(Target.Address, 3, 1) = "$" And Mid(Target.We are using Jenkins & Gerrit. Private Sub Worksheet_Change(ByVal Target As Range) If you don't like VBA, btw, you can do the same using VB.NET or C#. They could all call the same exact procedure, however, they all denote the same thing: the user changed the "focus", if you will. The Window activate and deactivate events should make this approach complete. You might also need to trap the Worksheet.Activate() and Worksheet.Deactivate() events (or the equivalent in the Workbook class) and/or the Workbook.Activate and Workbook.Deactivate() events so that you know when the user has switched worksheets and/or workbooks. Do not allow any unhandled errors, instead log them and/or "soft-report" an error as a message box to the user.) (Unless your issue is the "global variable reset" problem in VBA, for which there is only one solution: error handling everywhere.
#BASILISK EMULATOR PRE CODE#
However, you wouldn't need any if you utilize the Workbook class code behind (to trap the Workbook.SelectionChange event) or the Worksheet class code behind (to trap the Worksheet.SelectionChange) event. I'm not sure that I understand your objections to global variables here, you would only need 1 if you use the Application.SelectionChange event. It should do exactly as you want, firing any time the user clicks anywhere. SelectionChange is the event built into the Excel Object model for this.
'prevent Select event triggering again when we extend the selection below The code is as follows Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If you only wanted to trap selection of a single column of cells, you could insert a hidden column to the right, extend the selection to include the hidden cell to the right when the user clicked,and this gives you an editable cell which can be trapped every time it is clicked. Another option is to extend the selection by one cell (left/right/up/down),because this permits editing of the original cell, but will trigger a Select event if that cell is clicked again on its own. One option is to move the focus as I suggested above, but this prevents cell editing. Then the easiest way seems to be to move the focus off the selected cell, so that clicking it will trigger a Select event. However, if you want to allow the user to
0 kommentar(er)
