Using Prototypes for more than just user-testing

Other than for user-testing purposes, PM, Dev and QA are asking the designers in our company to create prototypes to be used as a guide along side of annotated wireframes and visual specs and the actual stories.
In a perfect…
vba excel sub to validate 4 ranges fails sometimes

on 5 sheets, cols AD, AI, AL, AW:BF are dates output as string(10) mm/dd/yyyy
users can update values
the following code succeeds completely on 3 of 5 sheets, missing 1 column on the other two. (one sheet, the last col; one sheet, a col in the middle of a contiguous range).
Has anyone seen this kind of behavior?
xlsm workbook in Office 365 on Windows 7 SP1 64-bit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet
Dim lRow As Long
Dim x As Range
Dim rng As Range
Set ws = ThisWorkbook.Worksheets(“MySheet”)
‘Set rng = ActiveSheet.Cells
lRow = ws.Cells(ws.Rows.Count, “A”).End(xlUp).Row
Set x = ActiveSheet.Union(Range(“AD2:AD” & lRow), Range(“AI2:AI” & lRow), Range(“AL2:AL” & lRow), Range(“AW2:BF” & lRow))
For Each c In x
If c.Value <> “” And Not IsDate(c) Then
c.ClearContents
MsgBox “Enter date mm/dd/yyyy.”
End If
Next c
End Sub
Design implications of Balloon Tooltip vs Rectangular Tooltip

I’m using a tooltip for a validation message and trying to weigh different design options.
I’m curious because in this walkthrough on using MaskedTextBox.ValidatingType, they go out of their way to suggest using ToolTip.IsBa…
UI-solution for iOS/Swift

I hope that this kind of question is welcome here If not, please excuse me !
I have a TableViewController in iOS/Swift on top of the workflow:
In my setup, this controller is use to update/add rows:
SetupViewControlle…
Does anyone know of any examples of the use of character counter on an input field?

I am working on a project that allows users to edit objects named by clicking on it using something similar to the HTML 5 Content-editable attribute.
Update:
The character limit is 30 not three.
Also the input field is m…
Should I be linking to the home-page on completion of checkout?

I’m creating a design for an ecommerce website1, which includes the checkout/order process. One element that I’m concerned about in the design is the ‘checkout completed’ page, specifically linking back to the home-page.
I’v…
Making the hamburger menu static is a good practice?

I’m working on an app that should be feasible with every version of iPad. Currently I have designed the screens for the iPhone.
This app is for a reputed bank and this app will be used by their customers for every need. This…
Telling user about action when clicking on a column in table

A table has a head row, which tells user the meaning of the column, like Google file table has name, id, mime type, created and modified date.
But, in addition to presenting information in the table, I wanted the user to be…
What’s a good single-word term that means "a user who’s signed in to your website"?

I’m trying to devise the standard nomenclature for our application, and I wanted to use a term that can be used across all our documentation and artifacts (i.e. user flows, scenario maps, etc.)
A Member is someone who’s regi…
Most used UX tools

Which is the best tool out there for creating prototypes and wireframes ? I am going to purchase a new computer and was wondering whether i should choose the Windows OS or iOS – given the fact that there are many tools that w…