Cell Tabulation

[ecohen1]

I have a form in my excel worksheet.
How to navigate from one cell to another.
For example, I have a cell B2 and a cell D9.
When I click on "TAB", I would like to move directly from B2 to D9

Thanks for your help

[Ron de Bruin]

Hi ecohen1

If you unlock B2 and D9 in the cell properties and protect the sheet the tab key do what you want.



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ecohen1" <[email protected]> wrote in message
news:[email protected]...
>
> I have a form in my excel worksheet.
> How to navigate from one cell to another.
> For example, I have a cell B2 and a cell D9.
> When I click on "TAB", I would like to move directly from B2 to D9
>
> Thanks for your help
>
>
> --
> ecohen1
> ------------------------------------------------------------------------
> ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
> View this thread: http://www.excelforum.com/showthread...hreadid=487952
>

[Lime]

Hello,
Try Unlocking the cells and then protect the sheet.

Format cell/protection click off locked then go to tools/protection/Protect
Sheet

Lime

"ecohen1" wrote:

>
> I have a form in my excel worksheet.
> How to navigate from one cell to another.
> For example, I have a cell B2 and a cell D9.
> When I click on "TAB", I would like to move directly from B2 to D9
>
> Thanks for your help
>
>
> --
> ecohen1
> ------------------------------------------------------------------------
> ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
> View this thread: http://www.excelforum.com/showthread...hreadid=487952
>
>

[ecohen1]

Thanks Ron.
But is this a way to do it programmatically or with a formula?

[Ron de Bruin]

Which Excel version do you use ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"ecohen1" <[email protected]> wrote in message
news:[email protected]...
>
> Thanks Ron.
> But is this a way to do it programmatically or with a formula?
>
>
> --
> ecohen1
> ------------------------------------------------------------------------
> ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
> View this thread: http://www.excelforum.com/showthread...hreadid=487952
>

[ecohen1]

I use Excel 2003

[Ron de Bruin]

Do you know that you can uncheck "Select locked cells" when you protect your sheet.
This way the user can't select locked cells.

If you only have a few cells to fill in and wat to use a macro then try this

Sub test_1()
Dim myRange As Range
Dim myCell As Range
Dim myAns As Variant

Set myRange = Range("I3,K7,M11")

For Each myCell In myRange.Cells
myAns = InputBox _
(prompt:="Please enter something for cell: " & myCell.Address, _
Title:="Get Data")
If myAns <> "" Then
myCell.Value = myAns
End If
Next myCell
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ecohen1" <[email protected]> wrote in message
news:[email protected]...
>
> I use Excel 2003
>
>
> --
> ecohen1
> ------------------------------------------------------------------------
> ecohen1's Profile: http://www.excelforum.com/member.php...o&userid=12988
> View this thread: http://www.excelforum.com/showthread...hreadid=487952
>

[ecohen1]

Thank you so much Ron