Unlocked Cells and tab feature

[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?

 

[Chip Pearson]

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)

 

[Debbie]

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

 

[Dave Peterson]

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.