Setting the Tab Order

[brianc2112]

Greetings,

I found that I can move between specific cells by using the name range
feature, but this has a limit of 255 characters, which means I can
only select about 25-30 cells.

The spreadsheet I am working on, I need to tab between 115 different
cells.

I set up a VB script to use:
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address

However, the code above requires me to change each cell before moving
to the next cell.


My delema is that sometimes I will need to change specific cells, and
other times I wont need to change them. Is there a different syntax
that I should be using to get the tab order set up correctly for both
cells that change and cells that remain unchanged?

Thanks!
Brian

 

[Dave Peterson]

How about an alternative.

If you select the range first (all 115 cells), then excel will follow that order
when you tab through the cells.

If you want to try:
Select the 2nd, 3rd, ..., 115th, then the 1st cell.
Give that a nice name via: Insert|Name|Define

Then you can use that name to select the 115 cells quickly.
(Edit|goto or F5 or gtrl-g and choosing the name or using the dropdown arrow of
the namebox.)

 

[brianc2112]

Hi Dave

Unfortunately, that has a limit of 255 characters in any given string.
Therefore you can only tab between 25 to 30 cells. Anything more than
that, and you will get an error due to going over the 255 character
limit.

I was hoping there was another way, but have yet to find anything so
far.

Thanks for your help!
Brian

 

[Dave Peterson]

Select your 115 cells.
Type the name in the namebox and hit enter.