Unlocked Cells and tab feature

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

I have created a form and I have several cells "unlocked"
so the user can input data.

I am unable to tab to each cell. I have to use the mouse
to go to each cell and click. Any way to make the tab
feature work between the unlocked cells?
 
Debbie,

You can use the EnableSelection property in a VBA macro:

Sub ChangeEnableSelection()
Dim WS As Worksheet
Set WS = ActiveSheet
WS.EnableSelection = xlUnlockedCells
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
I tried it and it still doesn't work. The Cells that I
want to tab through and sets of three cells each that I
have merged together. Is that the problem?

Debbie
 
I think excel gets confused with merged cells (at least xl2002 did).

If I merged a bunch of 3-cell groups in a column, then excel didn't have the
problem. But if I put those merged cells in the same row, it looks like excel
gets awfully confused and goes into a "tab" loop--just staying on that row (well
3 rows, since they had merged cells.)

And I had trouble using the arrow keys. Sooner or later, they went into a
loop. I could hit another arrow key and change direction, but then a different
loop started after awhile.
 
Back
Top