=ISNUMBER(MATCH(A1,B$1:B$20,FALSE)) will return TRUE if the name in A1 is in the range B1:B20. Enter it in say C1 and copy down as far as necessary. If you AutoFilter the data for column C = TRUE you will see which rows to delete. src: http://www.mrexcel.com/forum/excel-questions/55208-identify-duplicates-between-2-columns.html
Refer to an object on the Captivate stage
using widgetfactory, you can access captivate items on the stage - and if you can do that, you can do ANYTHING with ANYTHING - very exciting! override protected function enterRuntime():void { var mc:MovieClip = getSlideObjectByName("item"); mc.addEventListener(Event.ENTER_FRAME, function() {mc.rotation++}); } src:http://www.infosemantics.com.au/widgetking/2010/10/slip-sliding-away/
Captivate 6/7 recording size for 1024×768
For a popup window, with resizing enabled but no scrolling etc., popping up in a windows XP resolution of 1024x768, maximum recording size is: 1012x636. ------------ NEWSFLASH! 28.11.2014 with updated browsers forcing an address bar and the rest, new size: 1009x632 you can pop up the simulations with this js: window.open('try it.htm','simulation','scrollbars=0,width=1005,height=658,toolbar=0,menubar=0,location=0,status=0,resizeable=1'); The size is... Continue Reading →
Preloader in AS2
This was suprisingly annoying, AS2 is out of control. As usual Kirupa came through in the end. Here's a snippet: this.createEmptyMovieClip("container", "100"); my_mc = new MovieClipLoader(); preload = new Object(); my_mc.addListener(preload); preload.onLoadStart = function(targetMC) { trace("started loading "+targetMC); container._visible = false; bar._visible = true; border._visible = true; pText._visible = true; }; preload.onLoadProgress = function(targetMC, lBytes,... Continue Reading →
Line breaks in Captivate
Captivate uses \r instead of \n for line breaks.
adding commas to big number counts in AS3
Just a handy snippet I pinched: function addCommaInNumber (number : Number) : String { var integer : String = "" ; var fraction : String = "" ; var string : String = number.toString(); var array : Array = string.split("."); var regex : RegExp = /(\d+)(\d{3})/; integer = array[0]; while( regex.test(integer) ) { integer =... Continue Reading →
Getting TextField to show latest additions / last lines
Pretty straightforward: debugField.scrollV = debugField.maxScrollV;
Use jQuery to make an array of div items
var boxes = $('.box'); $(boxes[0]).click(function() { alert('hi'); }
Adding data to divs with jQuery
I am only beginning to experiment with JS with more depth, and have discovered jQuery has a data function which lets you store data against individual divs. Really useful for some bits and peices! $("#box0").data("uniqueID", 0); $("#box1").data("uniqueID", 1); Then to call it, $("#box0").click(function() { alert($(this).data("uniqueID")); I'll find out how to loop that through a set... Continue Reading →
Value from previous sheet in Excel
I changed this to not give an error if it finds nothing, but to produce 0. Used for accumulating overtime, so very important you see. Function PrevSheet(Range As Range) Application.Volatile PrevSheet = Application.Caller.Parent.Index If PrevSheet = 1 Then PrevSheet = 0 ElseIf Sheets(PrevSheet - 1).Type <> -4167 Then PrevSheet = CVErr(xlErrNA) Else PrevSheet = Sheets(PrevSheet... Continue Reading →
Javascript – re-focus on parent window after closing child
Great for CP simulations. As easy as below (run from the js-opened child window/simulation) window.opener.focus(); window.close();
Captivate replacing itself with [object] when running Javascript
I've been trying to run javascript through Captivate to do some nice popup windows for a sub-simulation. When the javascript finally works, it'd replace the main clip with [object] - ie. it would run the URL in its own URL, so you'd see '[object] displayed on screen, rather than the CP movie! Pretty silly. Anyway,... Continue Reading →