So I decided to post this demo for the benefit of those who might be watching this thread. Here are two screen grabs: noSelect has the cell Range .Select line disabled and yesSelect has it enabled. The result speaks for itself. How is that inefficient? (rhetorical).
Cheers.
Well, all I can say is that it works just as I expect it to. The destination changes in real time--same row, different column (C, D, E, ... L)--just by clicking the textbox.
You are missing the point. It is not usually necessary to activate or select a cell.
What are you doing after the TextBox is picked..
Instead of inputting data directly into the spreadsheet, the form acts as the UI. Selecting an input-box on the form should select the corresponding data location on the sheet, so that the entry made into the box is saved to the appropriate cell in the sheet.
So, wouldn't you agree then that I am on point? 
Thanks JD, worked like a charm!
|Why do you want to select cells?
It's a single cell; .Select and .Activate {seem} to do the same thing here. Cheers!
ActiveControl.Name would only return "False" if you have a control named "False" and it's active.
You're correct! ActiveControl.Name was actually returning the names of the navigation buttons. Thanks.
If {tBox1 is in Focus} Then
myCell = "A" & CStr(curRow)
Range(myCell).Select
End If
If {tBox2 is in Focus} Then
myCell = "B" & CStr(curRow)
Range(myCell).Select
End IfIf the cursor is moved to tBox2 (via mouse-click, Tab or Enter key), the relevant column is to be selected. (I've experimented with ActiveControl and ActiveControl.Name but they only return "False" as a value). Thanks for your help.